A quick way to get hammered: drink everytime he says the word "Macro".
@anasfrh
4 жыл бұрын
Natalia Vargas Sabean This deserves more likes 😂
@charles-y2z6c
4 жыл бұрын
But I will never get anything done. It’s bad enough already
@nataliavargassabean9998
4 жыл бұрын
@@charles-y2z6c That's why you get mAcRoS, to do stuff for you so you don't have to get anything done and you can just drink. Also... hey Siri, remind me to set up a Macro to drink every time I'm sober. Thanks. Also, Siri, cancel my AA meeting for tonight.
@wayneedmondson1065
5 жыл бұрын
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!
@fatihkaran
5 жыл бұрын
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
@Tubeytime
3 жыл бұрын
Is the macro designed to delete buttons? ;)
@MsOfficeLearning
3 жыл бұрын
Thank you your grafting tutorial videos.
@Atudo.
8 ай бұрын
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 ?
@beenay18
Жыл бұрын
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
@chrisfor
4 ай бұрын
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?
@suchithavishwa939
Жыл бұрын
super
@walterrabusa1814
2 жыл бұрын
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
@VipulVKGarg
4 жыл бұрын
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.
@tkdlance1
Жыл бұрын
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.
@beenay18
Жыл бұрын
calling subprocedure from button malfunctions but running it from vba editor works fine. what might be the reason?
@robertobjlano2216
Жыл бұрын
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 :(
@prasadsardeshmukh3898
4 жыл бұрын
Nicely explained 🤠 Liked the video and subscribed the channel 😉
@PeteJosephs
2 жыл бұрын
Thanks. I learned some good tips from your video.
@chrisrobidoux820
4 жыл бұрын
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
@boost0722
2 жыл бұрын
Thank You. This was very good tutorial.
@kenneth27089
Жыл бұрын
Very good explanation with best tips too! thank you
@jpeter63
3 жыл бұрын
Excellent job. thanks for your help
@piroozpakdel9415
2 жыл бұрын
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.
@BillHertzing
4 жыл бұрын
Thank you. This was very helpful in my workflow.
@anastasiagryn8236
3 жыл бұрын
Thank you very much, that's fantastic!
@Stephenpettitt198
Жыл бұрын
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
@Drjay18
2 жыл бұрын
i am trying macro for the first time and have no clue in making it work in steps. Like in debug, any ideas?
@DiKaPasisiil
2 жыл бұрын
You are an excellent teacher! Thank you for this video.
@Al-vw7qi
3 жыл бұрын
Thank you for making these videos short and brief. It is so helpful.
@yuzamei
3 жыл бұрын
now i can make fl studio
@frankmoore3220
Жыл бұрын
This is a great tutorial. Thank you very much for posting it. This was very helpful and easy to understand.
@ExcelCampus
Жыл бұрын
Thanks for your feedback, Frank! :)
@jeyamoorthy
2 жыл бұрын
Thanks Well explained
@caragliavincenzo
Жыл бұрын
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)?
@moali1836
2 жыл бұрын
Can you change the colour after the button has been pressed?
@luiwi826
2 жыл бұрын
Great video and well explained in a simple and direct way. Thanks!
@aaronsacks7539
Жыл бұрын
Hi, Any way to add the same button in multiple sheets at once?
@nicolebrown4376
Жыл бұрын
How do you get a macros button to disappear after you run the macro
@chrisnannhall
3 жыл бұрын
Very helpful, thank you!
@gssalian1
3 жыл бұрын
Thanks a lot.. .
@jesbruinsma1790
5 жыл бұрын
Is it possible for multiple Macros to be ran from 1 button?
@mikelennon1078
3 жыл бұрын
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?
@CullenMerritt
10 ай бұрын
🎯 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
@lucasmoreira3237
Жыл бұрын
Thank you.
@filco8494
2 ай бұрын
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
@TheRapasc
3 жыл бұрын
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")?
@ProtomanEX868
4 жыл бұрын
Thank you
@Msedk
4 жыл бұрын
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?
@ShubhamJain-du6xm
3 жыл бұрын
Simply Awesome.!
@Sunmeet4424
3 жыл бұрын
Nice 👍
@tnchv-a
Жыл бұрын
You're a life saver
@ExcelCampus
Жыл бұрын
Glad it helped, Juvie!
@michellebracken68
4 жыл бұрын
Clear and Easy, thanks!
@chabbsmc
4 жыл бұрын
Thanks!
@rosemaryfindley5206
5 жыл бұрын
Nice tip. Thanks
@marinki
3 жыл бұрын
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
@skrai4413
4 жыл бұрын
Sir, which version of excel are you using?, mine is 2007 and i don't see all those options...
@justinfrohnert6427
4 жыл бұрын
Fantastic thank you for such a clear and easy to understand tutorial.
@TradeConnectVVS
5 жыл бұрын
Just subscribed!
@Atudo.
8 ай бұрын
Will buttons work for this better??
@TatvagnaShah
3 жыл бұрын
Thank you!
@anon2436
4 жыл бұрын
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
@onelessbill
5 жыл бұрын
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.
@LoveNatureforabettertomorrow
4 жыл бұрын
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 😊
@JINGSONG168
4 жыл бұрын
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
@wesh7137
2 жыл бұрын
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?
@briancross6884
5 жыл бұрын
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!!!
@gordonsuploads
4 жыл бұрын
Great tutorial, saved me from those old clunky form buttons !
@paullang1525
Ай бұрын
VERY crisp and clear explanations - excellent - thank you!
@gulammustafahashmati5471
Жыл бұрын
Excellent guidance. Thanks
@ExcelCampus
Жыл бұрын
Glad it was helpful @gulammustafahashmati5471 😀
@wurimchoji2629
3 жыл бұрын
Hi, can I add a botten that will enable me print document directly from a designed template instead of using Ctr+P.
@michaelsong6306
3 жыл бұрын
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?
@anthonylobello5365
4 жыл бұрын
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.
@hugoprince5608
2 жыл бұрын
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
@nighthawkadventure
3 жыл бұрын
How do i add a button that i can click on and it highlights another cell for me ?
@alexanderstefanov3664
4 жыл бұрын
i am exhausted from a couple a days .. i got the job to create a button that create new file and copy there a couple of charts from 1st one. Pleaseee help me
@deepakshahani1295
4 жыл бұрын
I would like to create a button and record Marco so I can click and the picture will blow up to a slightly bigger size, than create a button to allow the picture to fit in back to its size
@tiramisu3336
5 жыл бұрын
Thank you 😊
@ginooliva5280
Ай бұрын
Thanks for sharing Jon! Greetings from Peru ...
@arvinattaie8415
4 жыл бұрын
how can i eliminate the question of running micro once tapping the bottom ? thanks
@rajeshghai1494
5 жыл бұрын
Sir how filter formula appear in excel
@ExcelCampus
5 жыл бұрын
Hi Rajesh, sorry I don't understand your question. Can you explain further?
@hilelfrankenthal8976
5 жыл бұрын
Thank You! Excellent, well explained, straightforward. Great Job. Helped me lots!
@sandeepchawla3776
4 жыл бұрын
Can we create button looks similar to particular cell size and shape ?
@alwayspositive999
5 жыл бұрын
Great video Jon - you explain very clearly and it's great listening to your videos and learning from them. Thanks
@ExcelCampus
5 жыл бұрын
Thanks! I appreciate your support and kind words. :-)
@ravindrapawar5295
5 жыл бұрын
@@ExcelCampus we yuhttiioooopooppoT fight your yioioo009999998 gf fb hhhhhhHjuuhu hi uiiu
@juanpablogavilanes7036
5 жыл бұрын
Thank you for the tutorial
@ricro880
4 жыл бұрын
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
@dustsettler4596
4 жыл бұрын
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.
@myentertainment3754
3 жыл бұрын
Hi Jon, How to run multiple macros without open no of modules
@Simba.Luna.
3 жыл бұрын
How do you delete it?
@madalingabriel2583
3 жыл бұрын
Where can I find the button immage options?
@anmolgarg63
3 жыл бұрын
Can anyone tell me in excel how can i enable automatic gstn enable by company name
@TravisFX
3 жыл бұрын
How do you make it look like its been clicked? Pressed etc..
@tharakaswalpita
3 жыл бұрын
Thanks
@petersanderson3364
4 жыл бұрын
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.
@KubieQ
5 жыл бұрын
How do we create a custom button on ribbon FOR MAC???
@nishant205
5 жыл бұрын
How can I click that macro button if my mouse is not working ?
@sasavienne
5 жыл бұрын
Thanks Jon. That is brilliant. 🌟 🌟 🌟 🌟 🌟
@snehalkatke1459
Жыл бұрын
How set one button in all macros in one excel
@srinuvenkat78
4 жыл бұрын
How activate the button to run the macro as per tool???
@mostafaali121
4 жыл бұрын
how to add save as pdf to excel menu bar ?
@wzproagar5730
4 жыл бұрын
Can i get permison too ur macro button
@yamunaprasad5655
7 ай бұрын
Great video very helpful
@deborahletke1777
4 жыл бұрын
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
@lisaw.1601
5 ай бұрын
Excellent tutorial. You told me exactly what I needed to know. Thank you!
Пікірлер: 136