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 ?
0
give a positive ratinggive a negative rating
15 Feb 2020 at 04:07 PM
Hi,

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.
0
give a positive ratinggive a negative rating
22 Feb 2020 at 05:11 PM
Tim
Share on FacebookShare on TwitterShare on LinkedInSend email
x
x
Follow us on Facebook
2022 AnswerTabsTermsContact us