View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Getting a "File Not Found" error when trying to show userform

Any chance you're clicking a button that runs a macro that shows the form?

If yes, check that button to see where that assigned macro really is. It could
be pointing to a different workbook.

If you look at VBA's help for "Trappable errors", you'll see that 361 just
describes what you described--that the object couldn't be loaded.



Bruce wrote:

I am creating a userform.I have created a macro that calls the userform

When I select the button, I get a "File not Found" error. When I then select
debug, it reports:
RUN-TIME ERROR '361'
Can't load or unload this object.

Macro code is:

Sub InputForm()

UserForm1.Show

End Sub

I do have my form named UserForm1 (defualt)

Right now the form is pretty simple.
I am just starting it.

Thanks
Bruce


--

Dave Peterson