Create macros in Excel without knowing of VBA programming

Can I create a macros in Excel document, when I don't know the Visual Basic for Applications programming language ?
15 Feb 2020 at 04:07 PM
0pnshow more

Yes, there is an option to create a marco in Excel without knowing VBA. The method is called macro recording. To record a macro, you need to have Developer ribbon displayed. You can enable the ribbon by going to Options and in the Customize Ribbon section, checking the Developer box:

excel create marco display developer ribbon to record

When you have the Developer ribbon displayed, click on Record Macro:

excel create macros record macro

Before recording of macro, you may consider to use absolute or relative reference. By default, Excel records macros in absolute mode.
22 Feb 2020 at 05:11 PM
0pnshow more
Share on FacebookShare on TwitterShare on LinkedInSend email
Follow us on Facebook & Twitter
2021 AnswerTabsTermsContact us