TorontoJim
Board Regular
- Joined
- Mar 16, 2009
- Messages
- 51
I'm using Excel 2007 on Winderz Vista at home and Excel 2003 on Winderz XP at work. I found an issue with the Object.Unload statement.
On my 2007 version, trying to use Me.Unload or userForm.Unload causes an error. It says "Method or Data Member not found".
Me.Hide works and Me.Show works. My problem is that the first window that shows up is Modal. The one that comes after it is Modeless. However, Excal VBA also won't allow you to show a modelss window when there is a modal window active.
Using Me.Hide just hides the modal window, it doesn't deactivate it.
So... being tenacious as I am and having just oodles of spare time to waste....
I found in the long run that you can use
BUT...only if you instantiate the form using:
I'm just sharing. Might stop someone else from beating their head on the wall.
On my 2007 version, trying to use Me.Unload or userForm.Unload causes an error. It says "Method or Data Member not found".
Code:
Me.Unload
frmInterface.Show
Me.Hide works and Me.Show works. My problem is that the first window that shows up is Modal. The one that comes after it is Modeless. However, Excal VBA also won't allow you to show a modelss window when there is a modal window active.
Code:
Me.Hide
frmInterface.Show
Using Me.Hide just hides the modal window, it doesn't deactivate it.
So... being tenacious as I am and having just oodles of spare time to waste....
I found in the long run that you can use
Code:
Unload someNiftyUserForm
BUT...only if you instantiate the form using:
Code:
Load someNiftyUserForm
someNiftyUserForm.Show
I'm just sharing. Might stop someone else from beating their head on the wall.