Thread: Compile Error?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TotallyConfused TotallyConfused is offline
external usenet poster
 
Posts: 144
Default Compile Error?


Please help! I compiled my VBA project and I got the following message.
"Compile Error Variable Not Defined". When I clicked on debug it took me to
the following code and highlighted the line frmMyUserform.Show vbModeless.
Can someone please help me understand why. Although my form is working fine.
Is this something I need to fix? If so how? Thank you for any help.

Private Sub UserForm2_Initialize()
Load UserForm2
UserForm2.Show
frmMyUserform.Show vbModeless

Me.FormDate = Format(Date, "mm-dd-yyyy")

End Sub