#New vba project excel how to
But for now we want to concentrate on how to record a VBA macro. Therefore, you have to edit the recorded macro by opening Visual Basic. Modify the macro: Usually you’d want to make the source code work universally, for example, on each sheet.Do the edits to your file which you want Excel to repeat.Give a name to the macro and confirm with “OK”.Make sure that ‘Developer’ got a tick mark on the right hand side. If you can’t see the Developer ribbon, right click on any button on any ribbon and click on ‘Customize the Ribbon’. Press on “Record Macro” on the Developer ribbon.
The following numbers are corresponding to the picture on the right hand side: You start recording, do your steps and stop recording. In the background, the source code is automatically created. Fortunately Excel provides an easy starting point: Record what you are doing and Excel can repeat it.
Let’s face is: creating VBA macros is real programming.