+ Reply to Thread
Results 1 to 14 of 14

How to launch macro or other userform after command button.

  1. #1
    Registered User
    Join Date
    04-03-2009
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    15

    How to launch macro or other userform after command button.

    I want to launch userform A when the user hits the command button on userform B, I already have a macro set up to launch UserForm A and tried adding it to the code but it doesn't work.

    This is what I have
    Please Login or Register  to view this content.
    What needs to be fixed or is there a way to just launch the other userform without trying to fire macro?

    Thanks in advance!

    P.S. I also posted this here
    Last edited by Karkas; 04-06-2009 at 07:51 PM. Reason: Cross post info added

  2. #2
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    Re: How to launch macro or other userform after command button.

    Please Login or Register  to view this content.
    I use that in one of my commandbutton codes at the end to fire a macro.

    And yes. The macro is named Mew.
    As most anything I come in contact with is also named.


    Hope that helps, if not, lemme know and we'll get something figured out for ya!

    mew!
    =IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)

  3. #3
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: How to launch macro or other userform after command button.

    Cross posted here

  4. #4
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    Re: How to launch macro or other userform after command button.

    Eh, he did leave a link in that post to this post, with a note saying that he'd already posted this question in this forum.

  5. #5
    Registered User
    Join Date
    04-03-2009
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    15

    Re: How to launch macro or other userform after command button.

    Quote Originally Posted by mewingkitty View Post
    Please Login or Register  to view this content.
    I use that in one of my commandbutton codes at the end to fire a macro.

    And yes. The macro is named Mew.
    As most anything I come in contact with is also named.


    Hope that helps, if not, lemme know and we'll get something figured out for ya!

    mew!
    So I replace
    Please Login or Register  to view this content.
    with...
    Please Login or Register  to view this content.
    I'm sure that's not right but I'm pretty noobish with macros & coding.

    Thanks so far though

  6. #6
    Forum Contributor mewingkitty's Avatar
    Join Date
    09-29-2008
    Location
    Fort McMurray, Alberta, Canada
    MS-Off Ver
    Excel 2003
    Posts
    949

    Re: How to launch macro or other userform after command button.

    Um, good effort off the start, but my xl file is named
    Ceiling Grid Diagram.xlsm
    And my Macro is named
    Mew

    Does that help?

  7. #7
    Registered User
    Join Date
    04-03-2009
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    15

    Re: How to launch macro or other userform after command button.

    Alright, I've tried using the application.run in several ways and I can't figure out how to make it work.

    Can you help spoon feed me a bit more please

    Thanks

  8. #8
    Registered User
    Join Date
    04-03-2009
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    15

    Re: How to launch macro or other userform after command button.

    Quote Originally Posted by mewingkitty View Post
    Um, good effort off the start, but my xl file is named
    Ceiling Grid Diagram.xlsm
    And my Macro is named
    Mew

    Does that help?


    Ahhhh, lemme try it & post back.

    TY

  9. #9
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,525

    Re: How to launch macro or other userform after command button.

    Without a mention of the other posting in this thread there is a violation of Rule 8 of the Forum Rules.

    It's actually strange that the user made the reference on that Board to this thread as they don't mind cross-posting where here does
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  10. #10
    Registered User
    Join Date
    04-03-2009
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    15

    Re: How to launch macro or other userform after command button.

    Still doesn't work, but I wonder if I should have a different header?

    Here is what I have so far...
    Please Login or Register  to view this content.
    Still wont launch the macro

  11. #11
    Registered User
    Join Date
    04-03-2009
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    15

    Re: How to launch macro or other userform after command button.

    Quote Originally Posted by Trebor76 View Post
    Without a mention of the other posting in this thread there is a violation of Rule 8 of the Forum Rules.

    It's actually strange that the user made the reference on that Board to this thread as they don't mind cross-posting where here does
    I put up that posting about a half hour after posting here 1st & not recieving a reply. I've never been on a message board where it was a very big concern... no problem though, I'll edit my 1st post to include it.

  12. #12
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to launch macro or other userform after command button.

    I've never been on a message board where it was a very big concern
    It's a big concern here. Thanks for complying.
    Entia non sunt multiplicanda sine necessitate

  13. #13
    Registered User
    Join Date
    04-03-2009
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    15

    Re: How to launch macro or other userform after command button.

    Got it from another poster in the other forum

    Please Login or Register  to view this content.

    Thanks for all the help guys and I'll be more vigilant of the rules next time I need help. (Prolly sooner than later

  14. #14
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to launch macro or other userform after command button.

    It's thoughtful of you to post your solution here, thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1