View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default Grayed out or disable?

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.