ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   User Form Error (https://www.excelbanter.com/excel-programming/337314-user-form-error.html)

theguz[_5_]

User Form Error
 

Any reason why VBA keeps giving me the same error. "Could not find the
specified object."

Here is the code that I used:

UserForm3.Show 'This is on a button from another form

The thing that is irritating me :mad: is that it has always worked
until this moment almost. I can even look at the stupid form so I have
no idea. Anyhelp would be great. Thanks in advance.

theguz


--
theguz
------------------------------------------------------------------------
theguz's Profile: http://www.excelforum.com/member.php...o&userid=24918
View this thread: http://www.excelforum.com/showthread...hreadid=395922


Simon Lloyd[_641_]

User Form Error
 

Hi, Does the actual userform still exist?, has it been inadvertantly
been deleted?, have a check in the vba editor in the forms folder and
see if it exists and is named the same!

HTH,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=395922


theguz[_7_]

User Form Error
 

Yeah it still exists, I can open it up in design view and everything,
but VBA still thinks it doesn't exist. I have scanned my code and
don't see any conflicting code anywhere.


--
theguz
------------------------------------------------------------------------
theguz's Profile: http://www.excelforum.com/member.php...o&userid=24918
View this thread: http://www.excelforum.com/showthread...hreadid=395922


Simon Lloyd[_645_]

User Form Error
 

well with out seeing your code i cant give a suggestion, maybe in your
code you are asking to close or Userform3.Hide before it is actually
open, if you want to0 post your code i will have a look and see if i
can help......no promises though because im as thick as they come
sometimes...lol.

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=395922



All times are GMT +1. The time now is 05:29 PM.

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