Togglebutton

  • Thread starter Thread starter ranswrt
  • Start date Start date
hi
not sure what you mean exactly by on/off but maybe
on
togglebutton1.enabled = true
off
togglebutton1.enabled = false

post back to clairfy if i misunderstood.

Regards
FSt1
 
I was looking for a code that would change it from sunken to raised. When it
is sunken it would be on and raised it would be off. I inserted
togglebuttons on my worksheet using the control toolbox
 
I would think you could just do this to "sink" it...

Worksheets("Sheet1").ToggleButton1.Value = True

where you would change the worksheet reference to you actual worksheet name
and, if you didn't use the default name for the ToggleButton, change it
also. By the way, setting the Value property to False to "raise" it.

Rick
 
thank you

Rick Rothstein (MVP - VB) said:
I would think you could just do this to "sink" it...

Worksheets("Sheet1").ToggleButton1.Value = True

where you would change the worksheet reference to you actual worksheet name
and, if you didn't use the default name for the ToggleButton, change it
also. By the way, setting the Value property to False to "raise" it.

Rick
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Toggle Button 2
Looping through buttons on a worksheet. 3
togglebutton to act like optionbutton 3
set toggleButtons to "pressed" by default 1
Toggle buttons 3
change the value of togglebuttons 1
linkedcell with togglebuttons problem 2
ActiveSheet (IF statement) 4

Back
Top