Is there a way to gray out or disable OptionButtons or CheckBoxes in a user
form if a condition is met, either on the spreadsheet (preferred if possible,
since I have conditions set up there already) or prior user form selections?
If so, how would you go about setting that up? Thanks for any help on this
in advance.

If condition Then
Checkbox1.Enabled = False
End If

RBS


"Cerberus" wrote in message
...
Is there a way to gray out or disable OptionButtons or CheckBoxes in a
user
form if a condition is met, either on the spreadsheet (preferred if
possible,
since I have conditions set up there already) or prior user form
selections?
If so, how would you go about setting that up? Thanks for any help on
this
in advance.

Thank you for your quick response. A stupid question from a new VBA user;
when you say "If condition Then", would I put something like

If Range("B2").Value = "N/A" Then

Or am I way off? Sorry for asking such basic stuff, I'll get it soon I hope.

"RB Smissaert" wrote:

If condition Then
Checkbox1.Enabled = False
End If

RBS


"Cerberus" wrote in message
...
Is there a way to gray out or disable OptionButtons or CheckBoxes in a
user
form if a condition is met, either on the spreadsheet (preferred if
possible,
since I have conditions set up there already) or prior user form
selections?
If so, how would you go about setting that up? Thanks for any help on
this
in advance.

Maybe, if B2 actually contained that #N/A error...

if activesheet.range("B2").text = "#N/A" then
or
if iserror(activesheet.range("b2").value) then

But if you really have the text N/A, try your original guess.



Cerberus wrote:

Thank you for your quick response. A stupid question from a new VBA user;
when you say "If condition Then", would I put something like

If Range("B2").Value = "N/A" Then

Or am I way off? Sorry for asking such basic stuff, I'll get it soon I hope.

"RB Smissaert" wrote:

If condition Then
Checkbox1.Enabled = False
End If

RBS


"Cerberus" wrote in message
...
Is there a way to gray out or disable OptionButtons or CheckBoxes in a
user
form if a condition is met, either on the spreadsheet (preferred if
possible,
since I have conditions set up there already) or prior user form
selections?
If so, how would you go about setting that up? Thanks for any help on
this
in advance.



--

Dave Peterson