THANK YOU SO MUCH FOR SO THOROUGHLY EXPLAINING THIS. I HAD NO IDEA HOW TO INSERT THE BUTTON. WATCHHING YOUR VIDEO I FOUND OUT IT IS JUST LIKE A REGULAR SHAPE! FORMED BY CLICKING AND DRAGGING THE CURSOR ON THE ACTIVE SHEET! THANKS.
Legend tells that anything you type in google, as long as it ends with "in Excel", will lead you to a video that starts with "Welcome to Excel Campus, my name is Jon and..." Amazing work Jon, thank you for existing.
Hi Jon, simple yet very useful. I have spent nearly 02 days trying to figure out how to jump from sheet to sheet without having to write a macro and here I am finally and you have saved me from lots of stress 😂 Thank you so much for the tutorial 😊
Jon, thanks great tutorial on creating a macro button from a shape - even an Excel novice like me managed it first time! clear and easy to follow - thanks
🎯 Key Takeaways for quick navigation: 00:00 📽️ *The video is about creating macro buttons in Excel.* 00:27 📋 *You should already have a macro created to follow along.* 01:21 🖍️ *Use the Shapes option in the Insert tab to create a button-like shape for the macro button.* 01:48 🎛️ *Edit the text on the shape to name the button and format it as desired.* 02:17 📁 *Assign a macro to the button by right-clicking and choosing "Assign Macro."* 03:13 🚀 *It's recommended to use macros stored in the same workbook to ensure others can run them.* 04:11 🎨 *Customize the button's style and appearance using the Format tab.* 05:04 📐 *You can control whether the button resizes with cells by adjusting its properties.* 06:13 📝 *Form control buttons are more limited in appearance customization compared to shapes.* 07:18 🚫 *Avoid using ActiveX control buttons due to potential sizing and compatibility issues.* Made with HARPA AI
Really nice video tutorial. I would like to know if you have made a video where you can connect a Macro (Sub) to Command Botton on UserForm (Privite Sub)?
Great tutorial and well explained, thank you for the info and advice. You have saved me hours of frustration trying to modify active x command buttons. Thanks again.
Thanks. I created a macro to duplicate an active sheet with a button but I would like to rename the duplicate sheet based on the text in a cell on another sheet in the workbook. How would I do this?
im preety new to exel, but im curious if you could controll other windows with an exel button click, my question is, can i create a button which copy pastes and choses tabs in other windows, or are the buttons only working inside of exel
Always great to use your teaching and glean from your insight. I've usually just used Form Control but I like the shape attributes. Will definitely being using this one. Your free vba macro webinars are supper - your website superb. You are one of the best Jon. THANKS!
I found a little workaround to "simulate" the pressed animation for the form. In your recording first record to delete the shadow effect, then comes your main macro, and after that insert the shadow again, then stop recording. It will be just a fraction of a millisecond but thats even enough to get that satisfiyng "pressed" feeling
Can you add the link and/or explain how you wrote the Macro for the Table of Contents? The video says you have a video explaing it but I dont see it anywhere.
Thanks. But how do I insert the button in different places? And when would I do that. So for example, I do a reformat each month. The next months data sheet comes in -- how do I add the button to the new worksheet?
Thanks for the learning experience. I'm not much of a fan of all the buttons though. I like the neatness of the cells themselves. Is there a way to use the cell as a button instead of a shape or form button?
Always enjoy and learn a lot from your videos and replies. How does one use the same button or shape to invoke a macro on the first click them another macro on the second click. For example, I want use the same button to hide and unhide a column. 1st click hide, 2nd click unhide (undo), 3rd click hide, etc.? Thank you.
Excel 2019- What is the easiest way to add command button to go to First Record, Last Record, Previous Record, Next Record, etc.? Can this be done without VBA?
Hey Jon.. thanks for the video on adding macro buttons. Question: Is there any way to get a shape to exhibit the "press" visualization that you see when clicking on a Form Control button? It looks like the Form Control press moves the dark border outline from the bottom and right edges to the top and left edges which gives the appearance of a "press" or "indentation.". Have you ever tried to accomplish the same via code to get that kind of animation effect on your shape buttons? Just curious.. might be a fun project. On shapes, I often use the rectangle with gradient fill and a round bevel shape effect to give the appearance of depth. But, it does not "depress" on a click. It would be great if Microsoft would add a "Like Control Button" shape effect for those of us who want to see a button-like action on the click of a shape being used as a button to fire a macro. Thanks again for all your valuable tips and resources Jon. Thumbs up!
My buttons aren’t working anymore, any idea how to restore them? I think I messed up the formatting of the spreadsheet when I pasted something into it from another sheet
Hi Sir Jon, Good day! how to enlarge MAcro button because my button is active x control and it shrink to very small button and Im having a hard time. Pls help Sir
I have a question. I’m working on one project and I don’t find the right formula for check boxes. Example: let’s take numbers from 1 to 20 and alocate 2 colours ( orange for odd and green for even ) and we have 4 results where need to stock data ( 1 to 10 = low / 11 to 20 high ) and we have box1 = low even green / box2 = low odd orange / box3 = high even green / box4 = high odd orange. When tick a box on number 1 for example, need in box1 = 1 but tick need to be gone after marking it and then let’s say we select 7, in box1 = 2 … sum and count formulas are not working unless I miss something. Is there any coding that needs to be ajusted ?
I did step 2 the same way and 2nd line up nothing happened? Should I be replacing something on the 2nd one? doing 20 more sheet ------------------------------- Sub Macro1() ' Macro1 Macro ' Run Opitimzer ' X = SolverSolve(True) End Sub --------------------------------------------------------------------- Sub Macro4() ' Macro4 Macro ' Clear Optimizer ' Range("I2").Select ActiveCell.FormulaR1C1 = "0" Selection.AutoFill Destination:=Range("I2:I201") Range("I2:I201").Select End Sub --------------------------------------------------------------------------------------------------------------------------- Sub Macro5() ' Macro5 Macro ' Mult2 ' X = SolverSolve(True) End Sub -------------------------------------------- Sub Macro6() ' Macro6 Macro ' Clear Optimizers ' Range("I2").Select ActiveCell.FormulaR1C1 = "0" Selection.AutoFill Destination:=Range("I2:I201") Range("I2:I201").Select End Sub
Great help, however, I have a large workbook and I need to change the size of the macro buttons which are 3 to a sheet. How can I change them all the same time without having to do each sheet separately? thanks
It was very helpful, Thanks, the button I created to create multiple tabs, works great but button gets copy to others sheets as well, I want button to stay on master tab only, please advise .
Good video but is there a way to click on a button("Show Purchases" or "Show Sales" or "Both") and have a cell show "Purchases" or "Sales" or "Purchases and Sales")?
I have created macro buttons for some time & they work well. The only problem I have now is that I do not know how to protect them from being modified. When I protect the worksheet, Excel automatically selects Edit objects & Edit scenarios in the Protect Sheet option. I do check Select unlocked cells only. That works in that you can click on the button & do what I want. For example, if the macro switches to a different worksheet - that works fine. However when I come back to the same sheet, even though I have protected that sheet, it is now unprotected! Jon - I don't understand this & am unable to figure this out! Thank you for all of your help!!!
Hi Jon, when I create a button and assign a macro to it, everytime I click (and run the macro) the button disappears. Do you have a solution for this behaviour? I did try the properties options, but it didn't help
is there a way to link two groups of clickable buttons that have different macros assigned to what you click on? i.e Group 1 = 1, 2 Group2 = a, b. you get a different macro when you click on 1a, 1b, 2a, or 2b
running sub-procedure from button malfunctions but running it from vba editor works fine? this problem started when i protected all worksheet. I wrote the following code to unprotect all the sheets at the beginning of sub-procedure and again protect all worksheet in the end of sub-procedure. Please help! sub name() Dim ws As Worksheet For Each ws In Worksheets ws.Unprotect code Dim ws As Worksheet For Each ws In Worksheets ws.Unprotect end sub
Hi Jon! Thank you very much for your collaboration. Would it be possible for you to show the grouping of the buttons let say 3 buttons and have it floating (view) while scrolling down. Thank you in advance.
THANK YOU SO MUCH FOR SO THOROUGHLY EXPLAINING THIS. I HAD NO IDEA HOW TO INSERT THE BUTTON. WATCHHING YOUR VIDEO I FOUND OUT IT IS JUST LIKE A REGULAR SHAPE! FORMED BY CLICKING AND DRAGGING THE CURSOR ON THE ACTIVE SHEET! THANKS.
Legend tells that anything you type in google, as long as it ends with "in Excel", will lead you to a video that starts with "Welcome to Excel Campus, my name is Jon and..."
Amazing work Jon, thank you for existing.
This is a great tutorial. Thank you very much for posting it. This was very helpful and easy to understand.
Thanks for your feedback, Frank! :)
Hi Jon, simple yet very useful. I have spent nearly 02 days trying to figure out how to jump from sheet to sheet without having to write a macro and here I am finally and you have saved me from lots of stress 😂 Thank you so much for the tutorial 😊
Thank you for making these videos short and brief. It is so helpful.
Excellent tutorial. You told me exactly what I needed to know. Thank you!
Great to hear that! 😀
Amazing Video! Clarified a lot of things I "sort of " understood! Thanks so much
You are an excellent teacher! Thank you for this video.
Very good explanation with best tips too! thank you
Thank You. This was very good tutorial.
Perfect solution to my problem
Thanks. I learned some good tips from your video.
VERY crisp and clear explanations - excellent - thank you!
You're a life saver
Glad it helped, Juvie!
Great video and well explained in a simple and direct way. Thanks!
Jon, thanks great tutorial on creating a macro button from a shape - even an Excel novice like me managed it first time! clear and easy to follow - thanks
Thanks for sharing Jon! Greetings from Peru ...
Excellent job. thanks for your help
Thanks, I learned something new !
Excellent guidance. Thanks
Glad it was helpful @gulammustafahashmati5471 😀
🎯 Key Takeaways for quick navigation:
00:00 📽️ *The video is about creating macro buttons in Excel.*
00:27 📋 *You should already have a macro created to follow along.*
01:21 🖍️ *Use the Shapes option in the Insert tab to create a button-like shape for the macro button.*
01:48 🎛️ *Edit the text on the shape to name the button and format it as desired.*
02:17 📁 *Assign a macro to the button by right-clicking and choosing "Assign Macro."*
03:13 🚀 *It's recommended to use macros stored in the same workbook to ensure others can run them.*
04:11 🎨 *Customize the button's style and appearance using the Format tab.*
05:04 📐 *You can control whether the button resizes with cells by adjusting its properties.*
06:13 📝 *Form control buttons are more limited in appearance customization compared to shapes.*
07:18 🚫 *Avoid using ActiveX control buttons due to potential sizing and compatibility issues.*
Made with HARPA AI
Great video Jon - you explain very clearly and it's great listening to your videos and learning from them. Thanks
Thanks! I appreciate your support and kind words. :-)
@@ExcelCampus we yuhttiioooopooppoT fight your yioioo009999998 gf fb hhhhhhHjuuhu hi uiiu
Thank you. This was very helpful in my workflow.
Thanks Well explained
Very helpful, thank you!
Nicely explained 🤠
Liked the video and subscribed the channel 😉
Thank you very much, that's fantastic!
Really nice video tutorial.
I would like to know if you have made a video where you can connect a Macro (Sub) to Command Botton on UserForm (Privite Sub)?
Great tutorial, saved me from those old clunky form buttons !
Clear and Easy, thanks!
Hi Jon, That's very insightful video. Can you please share the link of video where you created this macro. I need help with the code.
Great video very helpful
Simply Awesome.!
Great tutorial and well explained, thank you for the info and advice. You have saved me hours of frustration trying to modify active x command buttons. Thanks again.
Can you change the colour after the button has been pressed?
Fantastic thank you for such a clear and easy to understand tutorial.
Hi,
Any way to add the same button in multiple sheets at once?
Nice tip. Thanks
Thanks. I created a macro to duplicate an active sheet with a button but I would like to rename the duplicate sheet based on the text in a cell on another sheet in the workbook. How would I do this?
Thank you.
im preety new to exel, but im curious if you could controll other windows with an exel button click, my question is, can i create a button which copy pastes and choses tabs in other windows, or are the buttons only working inside of exel
Thank you!
Thank You! Excellent, well explained, straightforward. Great Job. Helped me lots!
Always great to use your teaching and glean from your insight. I've usually just used Form Control but I like the shape attributes. Will definitely being using this one. Your free vba macro webinars are supper - your website superb. You are one of the best Jon. THANKS!
Thank you James! I really appreciate the nice feedback, and your support. I'm happy to hear you will be putting these techniques to use. :-)
Thanks a lot.. .
Can we create button looks similar to particular cell size and shape ?
I found a little workaround to "simulate" the pressed animation for the form. In your recording first record to delete the shadow effect, then comes your main macro, and after that insert the shadow again, then stop recording. It will be just a fraction of a millisecond but thats even enough to get that satisfiyng "pressed" feeling
Will buttons work for this better??
calling subprocedure from button malfunctions but running it from vba editor works fine. what might be the reason?
Nice 👍
This could not be better.
Just subscribed!
Thanks!
Thank you
When I click my shape/button, I get the transform controls around it. How to I prevent the transform controls from showing up when I click my shape?
Excellent tutorial!
Thank you James! :-)
@@ExcelCampus You were easy to understand and concise without being overstating...You're very Welcome!
Thank you for the tutorial
Hi Jon,
How to run multiple macros without open no of modules
how can i eliminate the question of running micro once tapping the bottom ? thanks
Can you add the link and/or explain how you wrote the Macro for the Table of Contents? The video says you have a video explaing it but I dont see it anywhere.
Hello sir. Thanks for your video. But can you show us how to make a button "Back" to go back to the previous selected sheet ? Thank you
Thanks. But how do I insert the button in different places? And when would I do that. So for example, I do a reformat each month. The next months data sheet comes in -- how do I add the button to the new worksheet?
Thanks a lot for the video, helpful as always!
Thank you Travis! :-)
Thanks for the learning experience. I'm not much of a fan of all the buttons though. I like the neatness of the cells themselves. Is there a way to use the cell as a button instead of a shape or form button?
Always enjoy and learn a lot from your videos and replies. How does one use the same button or shape to invoke a macro on the first click them another macro on the second click. For example, I want use the same button to hide and unhide a column. 1st click hide, 2nd click unhide (undo), 3rd click hide, etc.? Thank you.
i am trying macro for the first time and have no clue in making it work in steps. Like in debug, any ideas?
thanks! Precise and thorough at the same time concise
Excel 2019- What is the easiest way to add command button to go to First Record, Last Record, Previous Record, Next Record, etc.? Can this be done without VBA?
Hi, can I add a botten that will enable me print document directly from a designed template instead of using Ctr+P.
Hey Jon.. thanks for the video on adding macro buttons. Question: Is there any way to get a shape to exhibit the "press" visualization that you see when clicking on a Form Control button? It looks like the Form Control press moves the dark border outline from the bottom and right edges to the top and left edges which gives the appearance of a "press" or "indentation.". Have you ever tried to accomplish the same via code to get that kind of animation effect on your shape buttons? Just curious.. might be a fun project. On shapes, I often use the rectangle with gradient fill and a round bevel shape effect to give the appearance of depth. But, it does not "depress" on a click. It would be great if Microsoft would add a "Like Control Button" shape effect for those of us who want to see a button-like action on the click of a shape being used as a button to fire a macro. Thanks again for all your valuable tips and resources Jon. Thumbs up!
Thank you 😊
My buttons aren’t working anymore, any idea how to restore them? I think I messed up the formatting of the spreadsheet when I pasted something into it from another sheet
Hi Sir Jon,
Good day!
how to enlarge MAcro button because my button is active x control and it shrink to very small button and Im having a hard time. Pls help Sir
I have a question. I’m working on one project and I don’t find the right formula for check boxes. Example: let’s take numbers from 1 to 20 and alocate 2 colours ( orange for odd and green for even ) and we have 4 results where need to stock data ( 1 to 10 = low / 11 to 20 high ) and we have box1 = low even green / box2 = low odd orange / box3 = high even green / box4 = high odd orange. When tick a box on number 1 for example, need in box1 = 1 but tick need to be gone after marking it and then let’s say we select 7, in box1 = 2 … sum and count formulas are not working unless I miss something. Is there any coding that needs to be ajusted ?
Great job brother 👍 doing great job
Excellent tutorial! Much appreciated!
Thanks Yulin! :-)
I have created a countdown timer command buttons for start and stop. How do I replicate these on others worksheets in the same work book
Where can I find the button immage options?
Thanks
Is is possible to create a button just o paste something I have copied from a website? I have been looking for that but cant find anything :(
Sir, which version of excel are you using?, mine is 2007 and i don't see all those options...
I did step 2 the same way and 2nd line up nothing happened? Should I be replacing something on the 2nd one?
doing 20 more sheet
-------------------------------
Sub Macro1()
'
Macro1 Macro
' Run Opitimzer
'
X = SolverSolve(True)
End Sub
---------------------------------------------------------------------
Sub Macro4()
'
Macro4 Macro
' Clear Optimizer
'
Range("I2").Select
ActiveCell.FormulaR1C1 = "0"
Selection.AutoFill Destination:=Range("I2:I201")
Range("I2:I201").Select
End Sub
---------------------------------------------------------------------------------------------------------------------------
Sub Macro5()
'
Macro5 Macro
' Mult2
'
X = SolverSolve(True)
End Sub
--------------------------------------------
Sub Macro6()
'
Macro6 Macro
' Clear Optimizers
'
Range("I2").Select
ActiveCell.FormulaR1C1 = "0"
Selection.AutoFill Destination:=Range("I2:I201")
Range("I2:I201").Select
End Sub
Is it possible for multiple Macros to be ran from 1 button?
How do i add a button that i can click on and it highlights another cell for me ?
Great help, however, I have a large workbook and I need to change the size of the macro buttons which are 3 to a sheet. How can I change them all the same time without having to do each sheet separately? thanks
It was very helpful, Thanks, the button I created to create multiple tabs, works great but button gets copy to others sheets as well, I want button to stay on master tab only, please advise .
How do you get a macros button to disappear after you run the macro
Thanks Jon. That is brilliant.
🌟 🌟 🌟 🌟 🌟
Good video but is there a way to click on a button("Show Purchases" or "Show Sales" or "Both") and have a cell show "Purchases" or "Sales" or "Purchases and Sales")?
I have created macro buttons for some time & they work well. The only problem I have now is that I do not know how to protect them from being modified. When I protect the worksheet, Excel automatically selects Edit objects & Edit scenarios in the Protect Sheet option. I do check Select unlocked cells only. That works in that you can click on the button & do what I want. For example, if the macro switches to a different worksheet - that works fine. However when I come back to the same sheet, even though I have protected that sheet, it is now unprotected!
Jon - I don't understand this & am unable to figure this out! Thank you for all of your help!!!
super
How do you make it look like its been clicked? Pressed etc..
Hi Jon, when I create a button and assign a macro to it, everytime I click (and run the macro) the button disappears. Do you have a solution for this behaviour? I did try the properties options, but it didn't help
Is the macro designed to delete buttons? ;)
How activate the button to run the macro as per tool???
is there a way to link two groups of clickable buttons that have different macros assigned to what you click on? i.e Group 1 = 1, 2 Group2 = a, b. you get a different macro when you click on 1a, 1b, 2a, or 2b
Can i use macro for texts too?
running sub-procedure from button malfunctions but running it from vba editor works fine?
this problem started when i protected all worksheet.
I wrote the following code to unprotect all the sheets at the beginning of sub-procedure
and again protect all worksheet in the end of sub-procedure.
Please help!
sub name()
Dim ws As Worksheet
For Each ws In Worksheets
ws.Unprotect
code
Dim ws As Worksheet
For Each ws In Worksheets
ws.Unprotect
end sub
Thanks-Jon
Thanks Saiful! :-)
how to add save as pdf to excel menu bar ?
Hi Jon! Thank you very much for your collaboration. Would it be possible for you to show the grouping of the buttons let say 3 buttons and have it floating (view) while scrolling down.
Thank you in advance.