View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Susan Susan is offline
external usenet poster
 
Posts: 1,117
Default disable option button on user form

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