Excel VBA for Beginners

 Excel VBA Message Box

Microsoft Excel

Before we start to code, some basic settings to be done in our Microsoft Excel.

Open Excel -> Options -> Customize Ribbon > Enable "Developer" from Main Tabs as shown in the image below.


Save the file as Macro Enabled Workbook.


GoTo the Developer Tab ->  Controls -> Insert > Button.


Change the name of the macro as you wish. Then select New, It will open the VBA Editor.


Declare the variable and create one input box to grab the name of the user.


That's it! You create your first macro in Excel!!



Keep Learning!!!














Comments

Popular Posts