![]() In the VBA window copy and paste the following line between Private Sub ToggleButton1_Click() and End Sub lines:Ĭaption = IIf(ToggleButton1.Value, "On", "Off").Right-click on your toggle button and select View Code.With a single line VBA code, you can program your toggle button label to show the status. Click on the Developer checkbox under the list of Main Tabs on the right. When the Excel Options window appears, click on the Customize Ribbon option on the left. Copy it down to by using tiny square at bottom right, like copying cells. To display the DEVELOPER tab, click on the File menu and then select Options from the drop down menu.Once the toggle button is in a cell, select the cell. ![]() You can also use Snap to Grid feature to fit object to cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |