You can also change the caption, name, colour, size, etc of the button by right clicking, selecting properties and then appropriately modifying the properties in the properties window.ĭouble click on the command button to start the Visual Basic editor in Excel. You can resize the command button by dragging along any of the 8 handles. Now drag the mouse in the Microsoft Excel document at a position of your choice to draw the command button.
Open the tool box by clicking on ‘view’, selecting ‘toolbars’ and finally clicking on the ‘control toolbox’ item. Use the tool box to insert a command button (ActiveX control) into your Microsoft Excel document and then provide the macro code to be executed when you click on it. How to use a command button in an Excel worksheet
0 kommentar(er)
