Thread: Exit Event
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael J. Malinsky Michael J. Malinsky is offline
external usenet poster
 
Posts: 37
Default Exit Event

I have a situation something like this:

Sub Main()
UserForm1.Show
End Sub

UserForm1 has ComboBox1, ComboBox2, TextBox1, CommandButton1 and
CommandButton2.

In the code for UserForm, I have something like:

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
MsgBox("Hi")
End Sub

When the code compiles, I get:

Compile error: Expected Function or variable

Can someone help me with this one?

TIA
Mike

--
Michael J. Malinsky