ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Getting a "File Not Found" error when trying to show userform (https://www.excelbanter.com/excel-programming/390912-getting-file-not-found-error-when-trying-show-userform.html)

Bruce[_2_]

Getting a "File Not Found" error when trying to show userform
 
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

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


All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com