How do toggle buttons return values in VBA?
Thread Content
I’m seeking help from experts: The value of a toggle button is only either true or false, but how can I make a number 2 appear in a cell in sheet1 whenever that button is pressed? What code to use?
Create a button in EXCEL that links to a macro. By writing the following statement in a macro: sheet1.cells(1,1).value=2, the value 2 will be displayed in cell A1.
It seems you’ve created the form yourself; when the toggle button is pressed, a Click event is triggered. The code is as follows: Private Sub ToggleButton1_Click() If ToggleButton1.Value = True Then Sheet1.Cells(1, 1).Value = 2 Else Sheet1.Cells(1, 1).Value = xxxx ‘Enter some other value if it’s FALSE’ End If End Sub
Thank you, coolmoonns from above