View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
avi avi is offline
external usenet poster
 
Posts: 195
Default EnableEvents problem

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