Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a form that contains an OptionButton that I want to initialize as true In order to disable the message box I code it like that Sub userform_initialize() Application.EnableEvents = False OptionButton1.Value = True Application.EnableEvents = True End Sub Private Sub OptionButton1_Click() MsgBox "Fired!" End Sub When the userform is loaded, i expect not to see the msgbox as events are disabled. The msgbox still appears. Do I miss something? Thanks Avi |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
EnableEvents | Excel Programming | |||
EnableEvents doesn't work | Excel Programming | |||
Application.EnableEvents help | Excel Programming | |||
Application.EnableEvents | Excel Programming | |||
Stopping the use of enableevents | Excel Programming |