If you are doing tasks in MS Excel which is repetitive then just click on the toolbar shortcut. These tasks are recorded, saved and run by clicking the shortcut. You can easily learn how to use macros to make your life easier and you can also compile and write your own visual basic modules.
You just have to follow the instructions given below and use your imagination to build macros.
First step is to build a macro for text formatting. Open a document or spreadsheet and from the tool menu, select macro then record new macro. Now a new window will be opened and in that window, type in a name for your macro. If you are creating it in MS word, then make sure that the “store macro in:” is set to all documents. By enabling it you can use in any word document. If using it in MS Excel then set “store the macro” either in “This workbook” or the ” Personal Macro Workbook,”. However it depend on whether the macro will be used in more than one workbook.
Now just click OK. After this step, you will see a small window called STOP at the top. You can move this window but do not close this window because it will stop your macro recording. Now select any text and apply the necessary change such as bold, underline, italic, text color or highlighting. Now when you are finished with the changes, just click the solid square in the small “Stop” window and your macro recording will stop.
You can add macro to a toolbar for one-click use. If you want to add it in MS word then right click on toolbar and select customize. Now in the customize window, select command tab and then select macros from the “Categories” column on the left. In MS excel, every thing is same in the process to add macros, just drag the custom button to the desired toolbar. Open the “Customize” window, right-click your new toolbar shortcut and select “Assign Macro.” Find and select your new macro and click “OK.”
Now its time to test your macro, it is very easy to test it, just select some text and click the shortcut. If the macro is not working then you can try re-recording. You just have to repeat all the steps given above. There is another way to do this, just go to tools menu and select macros and visual basic editor.
You can learn some visual basic programming by examining recorded macros and combining or changing them while using the program help files and the Microsoft knowledge base as learning tools. You can also combine them to automate a single shortcut. You can also organize new toolbars containing multiple macro shortcuts for formatting, changing margins, finding and replacing data or just opening menu items.
We recommend you to take care of steps while doing in MS office and Excel. Do not confuse yourself with the steps.