How to edit a recorded macro in Excel 

and use it explained in Hindi


Once the macro is recorded you can edit it in the Visual Basic editor.
We have for example changed the code '.Color' to '.ColorIndex' and applied a change which makes the font color red. Also we have changed the 'double underline' style to single underline style by tweaking the code. Later on we'll see how we can write our own macros using Visual Basic for Applications (VBA) to perform calculations and analysis. Also we'll be able to create interesting user interfaces by working with user forms and other controls. Although this video is in Hindi, you can still understand it if you put off the sound.


Watch the Excel VBA training Video on YouTube

How to edit a recorded macro in Excel