Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
if you want it disabled always, you can do that in the userform
properties. if you want it disabled due to a certain condition when the userform opens, you can do it programatically in the userform_initialize sub if xxxxxxxx then optionbutton1.enabled=false else optionbutton1.enabled=true end if where "xxxxxxx" is your condition. hope that helps. :) susan On May 4, 10:32*am, JH wrote: I have a large number of workbooks with an user form, the user form shows up when the workbook is open. *I am trying to disable one of the option buttons on the user form. *How can I do it programmatically? Thanks! JH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable Control Checkboxes based on Option Button result | Excel Programming | |||
option button (Form) | Excel Programming | |||
I need to disable to X on a user form | Excel Discussion (Misc queries) | |||
2 sets of option buttons on one user form? | Excel Programming | |||
Difficulties in VBA ( User form and option button) | Excel Programming |