Darpan Sharma

Hellos Guys,

Yes you saw it write, Macros basic to learn is just a piece of cake if we understand the concept of it.

Let me put it this way: Have you ever recorded a video in a mobile or any camera, I bet you have....same thing applies in Macros (for beginners), so without wasting much of your time lemme explain it how.

When we open our excel the first view of it seems very confusing due to the boxes which spreads all across the screen. We can see various tabs in the top line among which few are "Home", "Insert", "Page Layout", "Formula", "Data", etc etc..

Now in order to start the lesson lets go to the tab named as ""View".

 Now, once you click on it, the other step is to click on the dropdown button named  as "Macros". This is placed in the extreme right end of the screen.
Now, as shown above you need to click on the "Record Macro" button to start recording the sequence which you want to use it time and again just by clicking a button.

This time lets start with the simplest of the sequence, lets say you want to automate an action (making the selected cell red in colour).

Once you click on the Record Macro button, it will ask you to name the macro before proceeding further to record. Lets name it as (makemered), as the name of the macro doesn't allow any spaces in between.

Now just click on "OK".

Be careful now, everything you do now is being recorded. So, lets just go and change the colour of the selected cell to Red. (do nothing else).

Once done with that, go back to the "View" tab and click the macro dropdown and select "Stop Recording"

Now comes the interesting part: Select any shape from the "Insert" and give it your own look and feel. As shown below and also write something that urges you to click it time and again.
Now right click in the shape that you have selected and click on "Assign Macro" button. Once you do that a pop up box asks you for which macro is to be assigned with the shape. Just select the macro that you want to assign with the shape and then click on "OK".

Now comes the Magical Moment: Select any cell or a group of cell and then click in the shape that you have assigned the macro to, and see what happens.

Hope you liked it!!!!!.

If you face any issues or have any queries regarding it please mention in the comment box below,,,will definitely try and solve it out for you.....

Enjoy Learning :)