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

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.
give a positive ratinggive a negative rating
22 Feb 2020 at 05:11 PM
Share on FacebookShare on TwitterShare on LinkedInSend email
Find us on Facebook
2023 AnswerTabsTermsContact us
How would you rate your experience with AnswerTabs ?
Very badVery good
Thank you for your feedback.