Does not recognize Unload Userform1
Posted by Paul Magruder on April 11, 2001 4:15 AM
I have a UserForm with several command buttons on it that are used to navigate between several open workbooks. I am using the userform as a "Links Page".
Tha problem is that the word "Unload" is not recognized in the code. It will recognize UserForm1.hide, but not "Unload". I have several other workbooks wiith Userforms that I "Unload" without any problem. Excel 97 with Windows NT....
Any Suggestions?
Thanks in advance
Paul Magruder
Posted by Dave Hawley on April 11, 2001 5:35 AM
Hi Paul
This is strange! How are you using the command. It should be:
Unload UserForm1
if the code is housed outside of the UserForms Private module.
..OR
Unload Me
If the code is within the UserForms Private module.
DaveOzGrid Business Applications
Posted by Paul Magruder on April 11, 2001 6:00 AM
The Code is in a Private Sub. It will not reconize the word "Unload"?????
Posted by Dave Hawley on April 11, 2001 6:09 AM
Paul
Type: unload me
Exactly as shown (all lower case) does Excel automatically captilize it to read:
Unload Me
Dave
OzGrid Business Applications
Posted by Paul Magruder on April 11, 2001 6:13 AM
It just captilizes the "Me"
Posted by Dave Hawley on April 11, 2001 8:14 AM
Paul, Exporting the UserForm to your hard drive, Save the file, Import it back in again and rename it then Save agian.
If that doesn't help copy all controls on the UserForm to a new one, then copy over the ciode for all Controls.
If still no good try inserting a new userform and see if the Unload is recognised. You can send me the file if you like, but I wont be able to look at it for 7 hours.
DaveOzGrid Business Applications
Posted by Paul Magruder on April 11, 2001 11:33 AM
If that doesn't help copy all controls on the UserForm to a new one, then copy over the ciode for all Controls. If still no good try inserting a new userform and see if the Unload is recognised. You can send me the file if you like, but I wont be able to look at it for 7 hours.
Dave,
Tried eveything you suggested.. still won't reconize "Unload"..... I wish I could send you the file but it has links to the network with classifed info...Thanks for all your help...
This time & all the other times....
Thanks
Paul
