OMG !!! where does your inspiration come from Randy? Your explanation is way too clear. Anyone who understands english can understand your trainings. And even by watching only we can understand you. Thanks so much !!!
Great Keita, I am super glad you enjoy these basic trainings and I am really glad to help and share. Much appreciated. Thank you for your Likes, Shares & Comments. It really helps.
Brilliant stuff I'm becoming addicted to ur vids and the overwhelming potential of Excel! Just out of curiosity for fun, have you ever designed a "lotto power ball template" with all the random probabilities of selecting numbers?
Hi and thanks so much for your comment. I am so glad you enjoy the training. I have not designed a lotto power ball template, however it is certainly something I would consider if i get enough requests. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks the AttRow is the first available row in which we will place the newest Attendee. We use a long variable to hold this whole #. To learn more about these variables please check out my series here th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html I hope this helps and thanks so much.
fantastic training! one questione: is possible, maybe using an event, to force excel to wait some time? i'm creating a routine to refresh a pivot then save a copy of the workbook but often the file is duplicated before the update of all the pivots!!!
Hi and thanks. Yes for sure. You can use the Application.wait command to add any length of time to pause your code. I hope this helps and thanks so much.
Hi and thanks so much for your comment. Within a macro we often disable events to make the code run faster, but we must enable it before the macro ends. If there is a bug inside the macro, and the macro ends before events can be enabled, then we still must enable events. One way to do this is through the immediate window and another way is just to write a one line macro and run it like this Sub EnableEvents() Application.EnableEvents = True End Sub I hope this helps and thanks so much.
great training - Can you only have one change event per sheet. E.g you can't have 2 Worksheet_Change Events or any of the other change events more than once
Randy, thank you! again, I did the codes as you were playing the teaching and enjoyed, but I notices that when you click 4 to 5 times on the checked and unchecked cell for ADDED Items row (Keep in mind same cell) it jumps into the Enter Name field cell? How is that possible? can you explain? Thanks
Hi Jorge, thanks very much for your comment and glad you liked the training. When we use the selection change event, after we select a cell and excel performs whatever action we want it to perform, we may want to click the same cell again, however we can't do that because the current cell is already selected. So we tell Excel to select another cell using the Select command such as Range("A1").Select This allows us to select the same cell multiple times without having to select another cell first. I hope this helps and thanks so much.
Sir I have 2 questions No1.Sir can you tell what is a meaning of “Target” and which role is playing in code. No2. at 22:58 why did you (“G” & Target.Row).ValueEmpty Then I no what is it doing but I am not getting the logic behind it so please tell me Thank you..
Hi and thanks. Target is the cell you have changed and target.Row is the row of the changed cell. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourseRandyShared
![[#2024MAMA] G-DRAGON - 무제(Untitled, 2014)+POWER+HOME SWEET HOME+뱅뱅뱅+FANTASTIC BABY | Mnet 241123 방송](http://i.ytimg.com/vi/Ox29z5Nf1Uk/mqdefault.jpg)
😱 𝗨𝗡𝗕𝗘𝗟𝗜𝗘𝗩𝗔𝗕𝗟𝗘 𝟲𝟱% 𝗢𝗙𝗙 𝗧𝗛𝗜𝗦 𝗕𝗟𝗔𝗖𝗞 𝗙𝗥𝗜𝗗𝗔𝗬! 👉 www.excelforfreelancers.com/BFSale2024_YTPinnedComm
Super lecture by Randy as usual 👏👏
Great, thanks so much Raymond. I am so glad you enjoyed it.
OMG !!! where does your inspiration come from Randy?
Your explanation is way too clear. Anyone who understands english can understand your trainings.
And even by watching only we can understand you.
Thanks so much !!!
Great Keita, I am super glad you enjoy these basic trainings and I am really glad to help and share. Much appreciated. Thank you for your Likes, Shares & Comments. It really helps.
Mr. Austin I Always wandered for your incredible explanation ! Your are an Angel Realy
thanks a lot.
Thank you so very much, I really appreciate that Simeon, Thank you for your Likes, Shares & Comments. It really helps.
Great examples! Really handy!
Thanks so much Robbie, I really appreciate that
Brilliant stuff I'm becoming addicted to ur vids and the overwhelming potential of Excel! Just out of curiosity for fun, have you ever designed a "lotto power ball template" with all the random probabilities of selecting numbers?
Hi and thanks so much for your comment. I am so glad you enjoy the training. I have not designed a lotto power ball template, however it is certainly something I would consider if i get enough requests.
Thank you for your Likes, Shares & Comments. It really helps.
Thank you so much Randy for this amazing video.
For sure, you are very welcome Syed and thanks always for your continued support.
Thank you so much Randy for your great videos. Thank you so much for giving so much values for free. You've really helped me a lot. God bless you sir.
For sure, you are very welcome and I am so happy to be able to help and share. Much appreciated.
Good job!!
Thank you so very much, I really appreciate that
Can plz explain "Dim Attrow As Long". (17:45)
Why using Dim and Long function
Also plz explain 5th line
Range("B"& attrow).value=Target.value
Hi and thanks the AttRow is the first available row in which we will place the newest Attendee. We use a long variable to hold this whole #. To learn more about these variables please check out my series here th-cam.com/play/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z.html
I hope this helps and thanks so much.
THNX Randy nice Video
For sure, you are very welcome Henk and I am happy to help and share
Please also make a video on array.
HI and thanks. Yes for sure we will be covering arrays when we complete the foundational VBA functions.
I hope this helps and thanks so much.
fantastic training! one questione: is possible, maybe using an event, to force excel to wait some time? i'm creating a routine to refresh a pivot then save a copy of the workbook but often the file is duplicated before the update of all the pivots!!!
Hi and thanks. Yes for sure. You can use the Application.wait command to add any length of time to pause your code.
I hope this helps and thanks so much.
Hola, es posible fijar una fila superior (títulos) y una fila inferior (resultados) al mismo tiempo? Gracias.
Hola y gracias. Estoy seguro de que es posible. ¿Tiene un ejemplo de cómo se puede utilizar esto para poder indicarle la dirección correcta?
Sir why did you use immediate window to enable the events and why it was disabled
Thank you
Hi and thanks so much for your comment. Within a macro we often disable events to make the code run faster, but we must enable it before the macro ends. If there is a bug inside the macro, and the macro ends before events can be enabled, then we still must enable events. One way to do this is through the immediate window and another way is just to write a one line macro and run it like this
Sub EnableEvents()
Application.EnableEvents = True
End Sub
I hope this helps and thanks so much.
great training - Can you only have one change event per sheet. E.g you can't have 2 Worksheet_Change Events or any of the other change events more than once
Hi Peter, within the change event you can have an unlimited number of event codes. I hope this helps and thanks so much.
Randy, thank you! again, I did the codes as you were playing the teaching and enjoyed, but I notices that when you click 4 to 5 times on the checked and unchecked cell for ADDED Items row (Keep in mind same cell) it jumps into the Enter Name field cell? How is that possible? can you explain? Thanks
Hi Jorge, thanks very much for your comment and glad you liked the training. When we use the selection change event, after we select a cell and excel performs whatever action we want it to perform, we may want to click the same cell again, however we can't do that because the current cell is already selected.
So we tell Excel to select another cell using the Select command such as
Range("A1").Select
This allows us to select the same cell multiple times without having to select another cell first.
I hope this helps and thanks so much.
Sir I have 2 questions No1.Sir can you tell what is a meaning of “Target” and which role is playing in code. No2. at 22:58 why did you (“G” & Target.Row).ValueEmpty Then I no what is it doing but I am not getting the logic behind it so please tell me Thank you..
Hi and thanks. Target is the cell you have changed and target.Row is the row of the changed cell. You may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourseRandyShared