Nulling a option button

  • Thread starter Thread starter Keri
  • Start date Start date
K

Keri

I would like to "NULL" a group of option buttons if a cell
in the work book is "TRUE" and "ENABLE" a group of option
buttons if that cell is "FALSE" Any ideas??

Keri
 
Keri,

Do you mean

If Range("A1").value = "TRUE" Then
Activesheet.OptionButton1.Enabled = False
Activesheet.OptionButton2.Enabled = False
Else
Activesheet.OptionButton1.Enabled = True
Activesheet.OptionButton2.Enabled = True
End If
 
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

Option Buttons 1
Taking control from Option Button into RefEdit in Excel 2010 behaving oddly 4
Capturing YES/NO from two option buttons 3
Weird option button behavior 3
macro to select option button in option group 2
sorting: cleared/null v/s "" 3
Option buttons not responding 6
Referencing a Forms Button in a Worksheet 7

Back
Top