How to create a Macro Button in Excel?

 How to create a Macro Button in Excel?


How to insert button in Ms Excel?



MACROS IN EXCEL - https://youtu.be/tvw6rPbJHtc


If you have tasks in Microsoft Excel that you do repeatedly, you can record a macro to automate those tasks.

A macro is an action or a set of actions that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes.


Follow this link to get worksheet used in the tutorial:

https://drive.google.com/file/d/1JAqx1ADxHbhPcOHNhS1dDiyYXRfkY7a3/view?usp=sharing




# Some important point to remember before creating a Macro-

∆ If you want to save macros, then you must save your workbook in a macro-enabled format *.xlsm


∆ The macro name should not contain any spaces.


∆ Always fill in the description of the macro when creating one. This will help you and others to understand what the macro is doing.




MACRO BUTTONS

Macros make life easier. Buttons make life easier. 
You can literally run through a hundred steps with just one small click using macros and buttons–which, of course, is both empowering and gratifying.

# Three different types of buttons you can place on a worksheet.


Shapes


Form Control Buttons


ActiveX Control Buttons

In my opinion, the best way to create macro buttons is to use shapes. Shapes give us the most styling/formatting options, and we can make them look like buttons you click every day on modern web pages.



Comments

Post a Comment

If you have any doubt(s), please let me know.

Popular posts from this blog

Send Email from Excel using Hyperlink Function (PART 2)

Image
Send Email from Excel using Hyperlink Function (PART 2) In this Tutorial, you'll learn how to send Email from Excel using a Formula in Excel. You'll learn how to send Emails automatically to anyone. We'll use HYPERLINK Funtion of Excel in this video. I'll show you step by step everything like how to use Hyperlink formula. We'll learn How to type body of your email, How to type Subject for your email, and how to type CC for your Email using Hyperlink formula only. You simply need to follow the steps and do the same what i did in the video. So watch it carefully till the end. This tutorial will help you become creative with Hyperlink Formula of Excel. You just need to use this formula once and then simply Copy & paste it in other cells. We'll use some syntaxs like mailto: , ?subject= , etc. I have combined IF Function with HYPERLINK Function, Do watch the video till the end carefully to understand everything step by step. If you want to add a line break in ...
Read more

Complete Data Validation

Image
Complete Data Validation Hello Everyone, Welcome to Learn Xtra 😍 In this video, We'll learn Data Validation. We'll use some formulas also like Istext, Isnumber, etc. Learn how to use Custom, Date, Text Length, Decimal, etc in Data Validation. You just need to select the area when you want to edit and then go to DATA Tab and select Data Validation and then go to settings and from *Allow* select your desired word like Text Length, date, list, etc. Let's learn all these one by one- A) Text Length- It shows that what would be the length of your data. It can be either number or any text. B) Custom- You can type any kind of formula in custom. Like Isnumber formula, Istext formula and so on. C) Date- In date, you can select any date whatever you want. You can select 'Equal to' for selecting a particular data or You can select 'between' for selecting as many dates as you want between the 2 dates typed by you. D) List- You can make a list of texts or. Numbe...
Read more

Match function in Ms Excel

 Match function in Ms Excel MATCH FUNCTION IN EXCEL Learn Match Function in Excel with the help of examples. The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range. The MATCH formula uses the following arguments: Lookup_value (required argument) – This is the value that we want to look up. Lookup_array (required argument) – The data array that is to be searched. Match_type (optional argument) – It can be set to 1, 0, or -1 to return results. Follow this link to get worksheet used in the video https://drive.google.com/file/d/1-gSdzZ2HuhC2L-GOEiYEczK-JDf6VjGH/view?usp=sharing Watch the video till the end to learn everything in detail.If you have any doubts regarding this video or any other video, do let me know in the comment section. Please LIKE 👍🏻 SHARE 🤞🏻 & SUBSCRIBE 👆🏻MY CHANNEL to get notifications of all latest videos ❤️❤️ Follow me at: Facebook- https://bit.ly/2YKAOSy Telegram-...
Read more