Once again an incredible training about the varities of using VBA as a powerful tool to solve complex problems. Thank you so much for your time in teaching :)
For sure, you are very welcome Neren. These basic trainings also help me learn some of the fundamentals, so they are good for me as well. Thanks for your continued support over the years
Can you explain Sheets vs worksheets. A chart saved as a non-embedded object is a sheet. Also Chart objects are also shape objects and that wasn't discussed and may be an issue in looping over all shapes in a collection.
Hi and thanks Malcolm. I try to limit these basic VBA trainings to about 30 minutes, so I can't cover every possible option. I will try to get the other requests in a future video. Thanks again for your continued support.
Am loving your channel. Is it possible to create a football stats analysis sheet? Where say if I had all the data from previous matches I could click onto a team and it would tell me things like average goals per game, over/under goals, win percentage home and away etc. Thanks.
Hi and thanks so much for the nice idea. It would take some research however I will look into the possibility for a future video. Thank you for your Likes, Shares & Comments. It really helps.
Excellent run through ... brisk but easy to stop, play with code then resume. Very much appreciate the video and the series generally as I'm am currently building a data view that animates events over a building layout which is really pushing me out of my comfort zone (although I can still wave to it in the distance !). Quick question: is it considered good practice to name WorkSheet using the Codename rather than the Sheetname? As VBA doesn't auto-change code if a tab name changes, it can be a pain if the user (or I!) rename it and there is a tsunami of 'not found' errors. I'm not sure the best way to use the codename in referencing as I seem to get tied in knots trying to use it and messing up the syntax.
Hi and thanks very much. The answer is Yes, at least for me, I always change and use the code name (not the sheet name) within the code since users cannot change the code name. Referring to the code name is even easier than the sheet name within the code as you can refer to it such as SheetCodeName.Range("A1").value So its very easy and also more stable. I hope this helps and thanks so much.
Hello Randy, A question: I have a table with shapes that become visible when the target cell is selected, but when I drag the cell down, these shapes are duplicated. How can I avoid that?
Hi and thanks for your comment. Using VBA, I would move the cells out of the current cell (temporarily) by changing the left position such as Sheet1.Range("YourShape").left = Sheet1.Range("YourShape").left - 50 then after the drag and drop is performed I would move them back (hiding them won't really help) so they really need to be moved out of the cell as I can't think of another option at this point early in the morning :) Thank you for your Likes, Shares & Comments. It really helps.
HI and thanks and sorry about that. I will get that fixed. In the meantime, you can download the Object Master workbook here: freeworkbookdownloads.s3.us-east-2.amazonaws.com/Excel_Object_Mastery.xlsm I hope this helps and thanks so much.
Hi and thanks very much. I find tables very restricting and there are rules associated with table that I prefer not to use. Table require the user to conform to certain formats which I don't always want to follow. I do use them when i want to create pivot charts and tables. I hope this helps and thanks so much.
if you right click the file you downloaded and hit 'properties', see if there is an option at the bottom right (opposite "security") that allows you to "unblock" .. once done you wont have to do again for that file
HI and thanks Geoffrey. When you purchase the 175, pack, within the email there is a link to my website that shows you how to fix this once and for all as it is an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. TSo fix this I have outlined the following the steps on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
Hi and thanks for letting me know. Sorry about that and I will check on that. You can download the Object Mastery Workbook from the following link: www.dropbox.com/scl/fi/bh3ftk0b0464hs9isqqou/Excel_Object_Mastery.xlsm?rlkey=84bcx98lwcyntwundg1tbi6vb&dl=1 I hope this helps and thanks so much.
Hi and thanks, this video is focused on Excel Objects. If you would like to learn about userforms, I have a video on this here: th-cam.com/video/rTmq-EIkyi0/w-d-xo.html I hope this helps and thanks so much.
📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm
This may be the best one thus far...
For an initial explanation on VBA in Excel
Wow! Great thanks so much for that. I appreciate that.
Thank You for all the tutorials for VBA! I really appreciate it. I will buy your templates and training soon
Thank you so very much, I really appreciate that John
Once again an incredible training about the varities of using VBA as a powerful tool to solve complex problems. Thank you so much for your time in teaching :)
Thank you so very much, I really appreciate that and you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
A truly awesome training which I have yet to master. Thank you for your continuous training and inspiration.
For sure, you are very welcome Neren. These basic trainings also help me learn some of the fundamentals, so they are good for me as well. Thanks for your continued support over the years
Thank you so much Randy for this amazing video.
For sure, you are very welcome and I am happy to help. Thank you for your Likes, Shares & Comments. It really helps.
Excellent training session. Hugely helpful Sir
Thank you so very much, I really appreciate that and thank you for your Likes, Shares & Comments. It really helps.
Amazing! I love Excel
Thank you so very much, I really appreciate that Carlos. Much appreciated.
Thank you so very much. @@ExcelForFreelancers you is amazing
Superb..Postive vibes..👍
Thank you so very much, I really appreciate that
Is the find and find next masterclass ready? Wish it was done soon ☺️
Hi and thanks I have that on my list and will be addressing it in the very near future, within a few weeks. Thanks for your patience :)
Can you explain Sheets vs worksheets. A chart saved as a non-embedded object is a sheet. Also Chart objects are also shape objects and that wasn't discussed and may be an issue in looping over all shapes in a collection.
Hi and thanks Malcolm. I try to limit these basic VBA trainings to about 30 minutes, so I can't cover every possible option. I will try to get the other requests in a future video. Thanks again for your continued support.
Am loving your channel. Is it possible to create a football stats analysis sheet? Where say if I had all the data from previous matches I could click onto a team and it would tell me things like average goals per game, over/under goals, win percentage home and away etc. Thanks.
Hi and thanks so much for the nice idea. It would take some research however I will look into the possibility for a future video. Thank you for your Likes, Shares & Comments. It really helps.
Excellent run through ... brisk but easy to stop, play with code then resume. Very much appreciate the video and the series generally as I'm am currently building a data view that animates events over a building layout which is really pushing me out of my comfort zone (although I can still wave to it in the distance !).
Quick question: is it considered good practice to name WorkSheet using the Codename rather than the Sheetname? As VBA doesn't auto-change code if a tab name changes, it can be a pain if the user (or I!) rename it and there is a tsunami of 'not found' errors. I'm not sure the best way to use the codename in referencing as I seem to get tied in knots trying to use it and messing up the syntax.
Hi and thanks very much. The answer is Yes, at least for me, I always change and use the code name (not the sheet name) within the code since users cannot change the code name.
Referring to the code name is even easier than the sheet name within the code as you can refer to it such as
SheetCodeName.Range("A1").value
So its very easy and also more stable. I hope this helps and thanks so much.
Hello Randy, A question: I have a table with shapes that become visible when the target cell is selected, but when I drag the cell down, these shapes are duplicated. How can I avoid that?
Hi and thanks for your comment. Using VBA, I would move the cells out of the current cell (temporarily) by changing the left position such as
Sheet1.Range("YourShape").left = Sheet1.Range("YourShape").left - 50
then after the drag and drop is performed I would move them back (hiding them won't really help) so they really need to be moved out of the cell as I can't think of another option at this point early in the morning :)
Thank you for your Likes, Shares & Comments. It really helps.
Hello Mr. Randy, It seems like you attached the Workbook_Event file not the related file. Many thanks!
HI and thanks and sorry about that. I will get that fixed. In the meantime, you can download the Object Master workbook here:
freeworkbookdownloads.s3.us-east-2.amazonaws.com/Excel_Object_Mastery.xlsm
I hope this helps and thanks so much.
I’m curious as to why you don’t work with tables very often, especially when you work with databases.
Hi and thanks very much. I find tables very restricting and there are rules associated with table that I prefer not to use. Table require the user to conform to certain formats which I don't always want to follow. I do use them when i want to create pivot charts and tables. I hope this helps and thanks so much.
It does. Thank you!
❤❤❤ salute❤❤
Thanks so much. I appreciate that
I just found MS disabled macros
I don't know how to get around that.
This is probably why the 175 I bought I can't use.
if you right click the file you downloaded and hit 'properties', see if there is an option at the bottom right (opposite "security") that allows you to "unblock" .. once done you wont have to do again for that file
HI and thanks Geoffrey. When you purchase the 175, pack, within the email there is a link to my website that shows you how to fix this once and for all as it is an extra security measure, Microsoft disables macros from workbooks downloaded over the internet. TSo fix this I have outlined the following the steps on this page www.excelforfreelancers.com/how-to-fix-macro-blocking-issue/ I hope this helps and thanks so much.
Hey Randy. When I download this workbook I get the Workbook Events file :(
Hi and thanks for letting me know. Sorry about that and I will check on that. You can download the Object Mastery Workbook from the following link:
www.dropbox.com/scl/fi/bh3ftk0b0464hs9isqqou/Excel_Object_Mastery.xlsm?rlkey=84bcx98lwcyntwundg1tbi6vb&dl=1
I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you so much!! As always, your videos are amazing. I learn something new every time!!
For sure, you are very welcome and thanks so much
I really appreciate that and thank you
Why you just focus to worksheet object. Just jump to userform
Hi and thanks, this video is focused on Excel Objects. If you would like to learn about userforms, I have a video on this here: th-cam.com/video/rTmq-EIkyi0/w-d-xo.html
I hope this helps and thanks so much.