View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Capt. Bangs Capt. Bangs is offline
external usenet poster
 
Posts: 8
Default With Me statement

I'm trying to use a block of code to validate the user's data entry in a
form. I copied the relevant portions of code that was suggested by a VBA
book that begins with a "With Me" statment and ends with and "End With"
statement. I keep getting an error message telling me that my code includes
an "End With" statement without a "With" statement (which isn't the case!).
I have used this code before and it worked fine. Any suggestions? Also, I'm
not clear how the application knows that "Me" refers to the user form.

Thanks!