View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AOU AOU is offline
external usenet poster
 
Posts: 54
Default Textbox date format.

I have the following code to date format a textbox.

Private Sub TextBox1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
TextBox1.Value = Format(TextBox1.Value, "dd-mmm-yy")
End Sub

I keep getting the following message:

Compile error hidden module: userform 3

This code was done on office 2000. I am now using office 2003. Could that be
the problem?
Can anybody help!!

--
AOU