Thread: Form Names
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
 
Posts: 1,049
Default Form Names

place this:
OPTION EXPLICIT

at the top of your code module ... it will help enforce correct variable
name spelling


"Doug" wrote in message
...
I have a form named frmAbout with a capital A. In my code I have
frmabout.show, or frmabout.hide. They have small a. When I change to
capital A it changes back to small a. If I run the code I get an error
message "Object Variable or With Block Variable Not Set." If I change the
form name in Properties to frmabout with small a and re run the code, I
get
the same error. 2 questions: What causes the A to change? Is the error
related to the 'A' or could there be some other problem with my code.