STEP 5: Type in this code: Range(“A6”).Value = “Hello” STEP 4: Right-click on your new button and select View Code. STEP 3: Now go to Developer > Insert > ActiveX Controls > Buttonĭrag anywhere in the Excel spreadsheet to create button in Excel. Then select the Developer option under Main Tabs. STEP 2: Make sure the Customize Ribbon is selected. STEP 1: Right-click anywhere on your Ribbon and select Customize the Ribbon: You can use ActiveX controls to create button in Excel. The fastest way to run a macro will be to assign a macro to a button.
Running a macro can sometimes be a tedious task. DOWNLOAD EXCEL WORKBOOK Using ActiveX Control Buttons
