Get optionbutton status

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you you determine an optionbuttoms status from code? i.e. Is it true or fals

Bruce
 
Hi Bruce

Sub test()
With ActiveSheet.DrawingObjects("Option Button 2")
If .Value = 1 Then
MsgBox "Its true"
Else
MsgBox "Its false"
End If
End With
End Sub

--
XL2002
Regards

William

(e-mail address removed)

| How do you you determine an optionbuttoms status from code? i.e. Is it
true or false
|
| Bruce
 
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

peculiar condition: form optionbuttons lose position and linkedcellon row hide 1
Change OptionButton true/false status on all sheets 10
Counting OptionButtons 2
Follow up on this 3
OptionButton problem 1
Userform ... populate optionbutton from spreadsheet 5
Dynamically Create and ID OptionButtons, then insert Row; Loop 2
How to reference optionbutton within frame 0

Back
Top