You make it soo easy! I have been hesitant to learn macros because I thought it would be so challenging, but you make it so easy. I'm a 'why does it do that' person and need to know all the parts and you explained it all. Thank you!
Hi John, Your vedios on Macro helped me lot , I liked your style of explaining every thing in very easy, short and understandable way. Good luck to you and keep it up.
Hi Jon, you've been fantastic! thank you so much! I'm a VBA beginner and I tried to run a module written on the first file on a new workbook and for some reason part of the module ran on the first workbook, is it because certanin commands are workbook specific? many thanks!
Why you didn't code an "exit" to not execute the macro inmediatelly if the answer is "not"? Could it be possible to create an extenal routine called "test_execution" and there just prompt for the "yes" or "not" and abort all the execution accordingly? So, I could call to "test_execution" at the beginning of all my macros.
Thanks! You're a legend. Unfortunately I found this video AFTER I accidentally clicked a 'delete results' macro I created and assigned to a button... do'h. At least now it won't happen again ;-)
Nice, thanks! Please show us how to change Pivot Table Filter Reports Tabs in different colors or by VBA Code and then add them to our Tool Belt. Thanks
I’m new to excel. I appreciate your videos. I have copied my personal vbs file and exported my ui file. Is there a video that shows how to import those files on another computer?
Thank you - Great help! Can the message box (and the macro) be "Would you like to ACCEPT the result of the macro? This way it could be even more safer with such a message box.
Thanks for the great video. I've watched all 4 and they are great. When I open a new workbook, I can't run the functions that I have saved in my PERSONAL.XLSB unless I drag the module to the current workbook macros. Is this normal or have I missed something? If this is normal is there a way around this so I can use all my coded functions as soon as a new workbook opens without dragging modules?
Hi Melissa, I don't believe you can customize the ribbon to add macros buttons on the 2016 version of Excel yet. You can use an add-in file and write XML code to customize the ribbon. Here is a forum post that explains more. answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac/assign-macro-to-ribbon-button/cb37f050-d1b4-4cd3-be69-d2262e9ba213
Hi Jon, I did open a Personal Macro Workbook according to your instructions. When I run the 3-Sheet-Macro, it always opens a new Worksheet called PERSONAL, although there is no coding stating that in the macro? The command as such is only executed in this PERSONAL Worksheet even if I am working on another Worksheet. How come?
Hello Jon, very helpful video. I want to know that can we make any macro or popup massage who reply us that how many updates have been changed. For example - when we find any word and replace with some other word mannually the excel shows a pop-up massage that "10 changes made". Can we apply this in a macro. I hope you understand my query.
Jon, you are linking a macro from the workbook "PERSONAL.XLSB" to your Excel ribbon. This means that if the workbook "PERSONAL.XLSB" is not open, excel will open this workbook to find the macro. Are we able to add an error check to state that if the original workbook is not open then do not run the macro? I can't seem to find a solution to this issue, so any suggestions would be appreciated.
Hey Jon, that was a great video, thanks. So I got into VBA a few years back and designed a user form to keep inventory with bar codes. This time around I have designed this VBA user form to do quality checks for tech equipment. Some of the techs that will be using this have asked if they can skip out of the user form and just enter the work sheet to add the columns they are working on. This seems like a solution that may just work. Will this work for activating F5 to start the user forms and not start if the answer is no?
Here is a test for Jon to see if he reads these comments and how quickly he responds. I am writing this on 14 Dec 2022 at 19:58 UK time. Over to you Jon
Thank you jon! I've been trying to find a tutorial that just continues on the pressing of no but all these dorky kids with the other videos would only show how to make silly messages on the clicking of no and this is not very professional with my college project
This macro was working fine when I first typed it, and then it stopped to work. I've discovered that accidentally I've changed the vbYes into bvYes which has no meaning in the syntax . So, I fixed that typo. and it should work fine
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
You make it soo easy! I have been hesitant to learn macros because I thought it would be so challenging, but you make it so easy. I'm a 'why does it do that' person and need to know all the parts and you explained it all. Thank you!
You're so welcome, Kelly ! 😀
I am the same way. I like to know how everything works so I know what my importance is.
Thanks for the well made and informative and useful 4 part series!
Jon, you are amazing. You make all your trainings so easy to understand. Thank you!!!
Hi John, Your vedios on Macro helped me lot , I liked your style of explaining every thing in very easy, short and understandable way. Good luck to you and keep it up.
Glad you like them! 😀
This information is very informative and useful. The four part series was great. You explain it so simple that anyone can do it. Thank you
Great video, clear and simple explanations!! Thanks a lot Jon.
Excellent 4-part tutorial! Thanks for sharing!
Excellent class ! Your advice is so important and helpful. Thank you so much~ hope to follow all your courses
Very informative. Excellent! Thanks Jon, keep up!
Hi Jon, you've been fantastic! thank you so much! I'm a VBA beginner and I tried to run a module written on the first file on a new workbook and for some reason part of the module ran on the first workbook, is it because certanin commands are workbook specific? many thanks!
Why you didn't code an "exit" to not execute the macro inmediatelly if the answer is "not"?
Could it be possible to create an extenal routine called "test_execution" and there just prompt for the "yes" or "not" and abort all the execution accordingly? So, I could call to "test_execution" at the beginning of all my macros.
Fantastic video for beginners, thanks!!
Great topic and training session
It was indeed helpful and enjoyable at the same time, great thanks man!
Thanks this was an excellent series and #4 was GREAT!
Thanks! You're a legend. Unfortunately I found this video AFTER I accidentally clicked a 'delete results' macro I created and assigned to a button... do'h. At least now it won't happen again ;-)
Nice, thanks! Please show us how to change Pivot Table Filter Reports Tabs in different colors or by VBA Code and then add them to our Tool Belt. Thanks
Thank you Jon. This is a big help.
I’m new to excel. I appreciate your videos. I have copied my personal vbs file and exported my ui file. Is there a video that shows how to import those files on another computer?
I'm trying to share the macro I created with my team. How can I save it so all they need to do is enable an add-in? Thanks in advance!
Thanks Jon.. this would really helpful..
Thanks for sharing..
Glad it was helpful! 😀
how did you format the code in that editor
This is exactly what I needed.
Wonderful video sir
Thank you Jon. I wonder if there's a way to display an image containing math formulas or math symbols such as "Square root" in a message box ?
Thank you - Great help! Can the message box (and the macro) be "Would you like to ACCEPT the result of the macro? This way it could be even more safer with such a message box.
Hi, Thanks for sharing this. I used this vba query in my excel macro file. But im getting an error message like "Compile Error : Expected End With"
Thank you, very clear very easy!!!
Extremely useful macro tutorial series. Thanks a lot :-)
Thank you Jon, for this informative videos.
Thanks for the great video. I've watched all 4 and they are great. When I open a new workbook, I can't run the functions that I have saved in my PERSONAL.XLSB unless I drag the module to the current workbook macros. Is this normal or have I missed something? If this is normal is there a way around this so I can use all my coded functions as soon as a new workbook opens without dragging modules?
How do you add the macro tab on the ribbon for Mac? I can't do it the way you explained.
Hi Melissa, I don't believe you can customize the ribbon to add macros buttons on the 2016 version of Excel yet. You can use an add-in file and write XML code to customize the ribbon. Here is a forum post that explains more. answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_mac/assign-macro-to-ribbon-button/cb37f050-d1b4-4cd3-be69-d2262e9ba213
Hi Jon,
I did open a Personal Macro Workbook according to your instructions.
When I run the 3-Sheet-Macro, it always opens a new Worksheet called PERSONAL, although there is no coding stating that in the macro? The command as such is only executed in this PERSONAL Worksheet even if I am working on another Worksheet. How come?
oh followed. checked all data and i get the prompt yet it does not run the macro (i dont get my extra sheets) on chosing yes HMM
Thanks from Scotland, John.
If any cell change the popup will appear like vbyesNo once select yes then the result yes fill in specific cell same no answer pls guide code
Thanks, it is simple to follow and use
Hello Jon, very helpful video.
I want to know that can we make any macro or popup massage who reply us that how many updates have been changed.
For example - when we find any word and replace with some other word mannually the excel shows a pop-up massage that "10 changes made". Can we apply this in a macro.
I hope you understand my query.
thanks so much ......very much helpful info
Jon, you are linking a macro from the workbook "PERSONAL.XLSB" to your Excel ribbon. This means that if the workbook "PERSONAL.XLSB" is not open, excel will open this workbook to find the macro. Are we able to add an error check to state that if the original workbook is not open then do not run the macro? I can't seem to find a solution to this issue, so any suggestions would be appreciated.
thank you very much for the tutorial.that was awesome videos and easy access to all personnel micro
Very informative. Thanks.
Hey Jon, that was a great video, thanks. So I got into VBA a few years back and designed a user form to keep inventory with bar codes. This time around I have designed this VBA user form to do quality checks for tech equipment. Some of the techs that will be using this have asked if they can skip out of the user form and just enter the work sheet to add the columns they are working on. This seems like a solution that may just work. Will this work for activating F5 to start the user forms and not start if the answer is no?
Thanks Jon
Great Video
Thanks a lot, this is a great macro and very helpful. Just implemented and it works.
hi john please tell me how to creat add-ins? I am waiting your reply thanks
Thanks Jon, very good/useful...
Sir how can i print a hidden sheet.
Thanks for the great info
Hello Jon
Thank you for this amazing series, I have one question! How did you align your 3 lines text code by one click ?
(In 5:44)
Thank u in advance
Select the three lines and press Tab.
Here is a test for Jon to see if he reads these comments and how quickly he responds. I am writing this on 14 Dec 2022 at 19:58 UK time. Over to you Jon
Hello Zia! 😀
I tried to type Dim Answer~~~~ but only question marks came out. I don't know why 😢😢
Thank you jon! I've been trying to find a tutorial that just continues on the pressing of no but all these dorky kids with the other videos would only show how to make silly messages on the clicking of no and this is not very professional with my college project
Truly very helful . Thank you a lot
This macro was working fine when I first typed it, and then it stopped to work. I've discovered that accidentally I've changed the vbYes into bvYes which has no meaning in the syntax . So, I fixed that typo. and it should work fine
Thankyou
Thank you :)
Thanks.
I just came here to learn how to mess with my friends making annoying msgboxes
Very helpful, I have been running macros for so long, I run some of them by mistake and ruined some of my work jajaja
Excellent!!
How to add msg pop up to a code after its macro Run..??? you have done for before its macro run
Very useful.. Teacher