Some general comments...
1. Hide a user form instead of unloading if you are going to display it multiple times.
2. Unload it when done with it.
3. A userform is loaded automatically when it is referenced...
UserForm13.TextBox1.Value = "Mush" - loads the form.
4. Code like this can help unload multiple userforms...
lngCounter = UserForms.Count
If lngCounter 0 Then
For N = 1 To lngCounter
Unload UserForms(N - 1)
Next
End If
5. Pioneers can get arrows in the back. (xl2007)
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"ZipCurs"
wrote in message
I eager to get some help and am resubmitting this from yesterday... I have a
macro with about 20 userforms. As far as I can tell, it worked great in
earlier versions of Excel. I am now using the macro on a new machine with
Excel 2007. After I call the exact same sub-routine a bunch of times, I get:
Run-time error '75': Could not find specified object.
The debugger highlights "Load UserForm13". I can see it is right there in
VB interface and it had just accessed it 3-20 times prior to failing. I
can't open it though. There is a lot of other code, so I haven't bothered to
provide this.
Any help or guidance would greatly be appreciated. Thank you
in advance.