Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: UserForm Show. Cannot Find The Specified Object

  1. #1
    Join Date
    1st December 2006
    Posts
    22

    UserForm Show. Cannot Find The Specified Object

    Hi guys,

    I know there is something I am missing here and I can't really find the solution I need in past threads. I have a macro that calls about three macros in a row, then once it has done those tasks, I want it to show a particular userform using the userform.show statement.

    However, when it comes to show the userform I get an error saying that it cannot find the specified object?

    This is quite frustrating and I think I fixed it in another part a while ago, but I can't remember how.

    Any suggestions?
    Last edited by Dave Hawley; January 10th, 2007 at 14:52.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    1st December 2006
    Posts
    1,054

    Re: User Form Won't Show After Running Other Macros

    Hi,

    A couple of silly questions to start with, but are you sure you're referring to the exact name of the form? For instance, if the form is called 'MyWay' is your code as follows:

    MyWay.Show

    and not some derivative such as My Way.show

    If the code is referring the form correctly, is the macro actually bombing out when it tries to open the form (stepping through the macro will pinpoint this) or at another part?

    Hope this helps.

    Kind regards,

    Robert
    : D

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    1st December 2006
    Posts
    22

    Re: User Form Won't Show After Running Other Macros

    Hi Robert,

    I had all the names correct (first thing I checked)

    The macro is definately bombing out when it tries to show the form. All the other macro's that are run before trying to show the form are run successfully.

    Don't worry too much, I managed to get around the problem simply by making another macro which contained the userform.show statement only. I then just referenced this from inside the first macro and it seems to work fine now.

    Thanks for your interest though.

    Cheers.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Userform Initialize vs Userform Show
    By bbromley in forum EXCEL HELP
    Replies: 17
    Last Post: May 5th, 2011, 06:02
  2. Replies: 4
    Last Post: March 11th, 2008, 18:54
  3. Replies: 3
    Last Post: July 6th, 2007, 01:48
  4. Fill UserForm ListBox & Show Userform
    By JFrench in forum EXCEL HELP
    Replies: 7
    Last Post: November 14th, 2006, 03:31
  5. Object Required Error On UserForm Show
    By Speluchi in forum EXCEL HELP
    Replies: 1
    Last Post: July 6th, 2006, 15:23

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno