View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Error Loading UserForm


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.