How to install your new Excel VBA code
Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
How to run your new Excel VBA code
Press Alt-F8 to open the macro list
Select a macro in the list
Click the Run button
Obtained from the OzGrid Help Forum.
Solution provided by AlanSidman.
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
See also:
| Excel/VBA Golden Rules. These should NOT be optional |
| How to use a VBA code to change cells colours based on date in other cells |
| How to use VBA code to check interactions in the formula bar |
| How to use a VBA code for clipart |
| How to use Excel VBA macro to convert multiple columns to multiple rows |
| How to create VBA to place current month and year in a cell |
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
