I really like your tutorial webnars. Clear & logical. Very impressive. I have learned Pivot Table, VLookup, Xlooup, and etc etc. Now I start to learn Macro. My job become more and more effciency. Your tutorials are the NO1 choices.
Huh this looks like a cool hobby to work on in the future. To incorporate in the corporate world as a non-freelancer to be more versatile, communicate and be more considerate to others. I don't know much about VBA or programing but it's another area to grow for fun and improve career trajectory in the future decade
Hi Jon, Firstly I have been watching your videos and I think you have a genuine gift for teaching and the videos are wonderful and executed perfectly. I am an average VBA programmer but have been out of touch these last few years due to a change in job role. I was wondering if you would consider doing one of your excellent production on reading from PDF files using "Reference libraries"
Jon excellent video thanks for sharing. What can I add to your code that will group the shapes? When it makes those thumbnails it creates 2 shapes and I'd like to combine them to 1 shape.
Hey John, I'm a fairly decent vba coder and been looking for ways to up my game to highly advanced. This was a GREAT video and I appreciate your time and effort in making it. I may consider signing up for you class depending on how it is set up.
thank you so much for the tutorial. I created a save button but when I click on it, I get this message. "Cannot run the macro… the macro may not be available in this workbook" I already, set the trust center setting to trusted location. Thanks
I have an excel file for work that I created that uses around 10,000 "unique" equations. Each cells references other cells to compute a calculation. Can I use VBA Macros?
Hi John, I have registered for the webinar on 13th. Thank you sir for providing this good opportunities to learn ourselves. I have a doubt like we have developed a macro in one workbook and closed it. So, now we have opened new work book how can we run that macro from closed work book in new work book.
Once you edit / record a macro try saving it as .xlam (this will save as excel add in) instead of .xlsm. Then you can enable that add in and make it work in any excel file. I have tried in Ms Excel 2013, and it is working fine.
Hi Siva, You can also add code to your macro to open a specific workbook, then run additional lines of code on that workbook or even a set of workbooks.
Hey Jon, I would like to buy even a recording of your course (the link says it's no longer offered). I need to do exactly what you described in #5 @8:55. I made a budget for a business with 25 offices by scratch. I need to update it weekly/monthly. Please help, haha, I've search everywhere. I can teach myself, just need recording.
Hi Cam, Sorry about that. I just updated the link and also created a web page where you can download the file. Here is the link. www.excelcampus.com/vba/5-uses-for-macros/ There is a download section on that page where you can download the file. I hope that helps.
You go to File>>Options>>Customize Ribon then add a custom custom option. but you can look up from this link www.google.com/search?q=how+to+show+the+custom+tool+bar+for+My+Macros+in+excel&rlz=1C1GCEB_enFR853FR853&oq=how+to+show+the+custom+tool+bar+for+My+Macros+in+excel&aqs=chrome..69i57j33l3.20948j0j7&sourceid=chrome&ie=UTF-8#kpvalbx=1
I really like your tutorial webnars. Clear & logical. Very impressive. I have learned Pivot Table, VLookup, Xlooup, and etc etc. Now I start to learn Macro. My job become more and more effciency. Your tutorials are the NO1 choices.
All the 5 are most useful in tips while working on vba. great video...
I wasnt lucky enough to be accepted on my online job because I dont know anything ahout VBA. Thanks John for the info. Love your voice.
Thank you so much!
Huh this looks like a cool hobby to work on in the future. To incorporate in the corporate world as a non-freelancer to be more versatile, communicate and be more considerate to others. I don't know much about VBA or programing but it's another area to grow for fun and improve career trajectory in the future decade
Thank you for the tutorial, it is very educative
Hi Jon, Firstly I have been watching your videos and I think you have a genuine gift for teaching and the videos are wonderful and executed perfectly. I am an average VBA programmer but have been out of touch these last few years due to a change in job role. I was wondering if you would consider doing one of your excellent production on reading from PDF files using "Reference libraries"
Thank you Neil! I really appreciate the nice feedback! I will add that topic to my list for future videos. Thanks again and have a nice day! :-)
Thank you for the response, I look forward to seeing this production. it night here BTW LOL
Macro macro - god, I have to learn this for work but I cannot think of anything less interesting in the world.
Great.. Thank you sir. Appreciate ur works very much
Woooahhhhh!! Thanks homie
Jon excellent video thanks for sharing. What can I add to your code that will group the shapes? When it makes those thumbnails it creates 2 shapes and I'd like to combine them to 1 shape.
Hey John, I'm a fairly decent vba coder and been looking for ways to up my game to highly advanced. This was a GREAT video and I appreciate your time and effort in making it. I may consider signing up for you class depending on how it is set up.
Do you ever teach users that aren't beginners btw?
thank you so much for the tutorial. I created a save button but when I click on it, I get this message. "Cannot run the macro… the macro may not be available in this workbook" I already, set the trust center setting to trusted location. Thanks
I have an excel file for work that I created that uses around 10,000 "unique" equations. Each cells references other cells to compute a calculation.
Can I use VBA Macros?
Good for VBA programming and VB6 programming
Hi I'm new in excel.there are a lot of videos on excel but I can't understand from where I should start. please give a suggestion.
listen in that case i will help you...please visit my e lesson visit....basic to end....you will get good knowledge about excel...
Hi John, I have registered for the webinar on 13th. Thank you sir for providing this good opportunities to learn ourselves.
I have a doubt like we have developed a macro in one workbook and closed it. So, now we have opened new work book how can we run that macro from closed work book in new work book.
Once you edit / record a macro try saving it as .xlam (this will save as excel add in) instead of .xlsm. Then you can enable that add in and make it work in any excel file. I have tried in Ms Excel 2013, and it is working fine.
Hi Siva, You can also add code to your macro to open a specific workbook, then run additional lines of code on that workbook or even a set of workbooks.
Hey Jon, I would like to buy even a recording of your course (the link says it's no longer offered). I need to do exactly what you described in #5 @8:55. I made a budget for a business with 25 offices by scratch. I need to update it weekly/monthly. Please help, haha, I've search everywhere. I can teach myself, just need recording.
Hello Sir, Can you please teach me how to make coding for our sheets in excel according to data which is maintain. Please reply must
JULY Wednesday 31
Hi Jon. I've tried to download the above file but nothing is happening. Would you please send the file to me:
Hi Cam, Sorry about that. I just updated the link and also created a web page where you can download the file. Here is the link. www.excelcampus.com/vba/5-uses-for-macros/
There is a download section on that page where you can download the file. I hope that helps.
How did you make the "My Macros" tab?
You go to File>>Options>>Customize Ribon then add a custom custom option. but you can look up from this link www.google.com/search?q=how+to+show+the+custom+tool+bar+for+My+Macros+in+excel&rlz=1C1GCEB_enFR853FR853&oq=how+to+show+the+custom+tool+bar+for+My+Macros+in+excel&aqs=chrome..69i57j33l3.20948j0j7&sourceid=chrome&ie=UTF-8#kpvalbx=1
At 7:00 I notice the excel assumed your gender
It would be OK if you are a female.