Set the tick at “Create a copy” and press OK. Therefore, right click on the worksheet name on the bottom of the screen.Press “Record Macro” on the Developer ribbon.Now you want to copy it and change one value.

Let’s assume the following situation: You prepared an Excel sheet. Therefore press F12 (‘Save as’) and select ‘Excel Macro-Enabled Workbook’ as the file type.Įxample: You want to copy the VBA worksheet 6 times and change the value in cell B5. Please note that you have to save your file as a macro enabled file in order to save your recorded VBA macro as well. 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.

New vba project excel