+ Reply to Thread
Results 1 to 3 of 3

Run different macros based on user response to Input Box?

  1. #1
    Registered User
    Join Date
    10-26-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2010
    Posts
    50

    Question Run different macros based on user response to Input Box?

    I'm having difficulty using an input box to call two slightly different macros. The macros are located in different modules, and just can't seem to get the call command to them correct:

    Please Login or Register  to view this content.
    Any help trying to figure out how to correct my fruitless attempts at calling "Adjusted" and "MakeFreqTable" would be greatly appreciated! Thank you!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-09-2011
    Location
    Germany
    MS-Off Ver
    Excel 2016
    Posts
    194

    Re: Run different macros based on user response to Input Box?

    Hi,

    did you notice there are two subs called adjusted in your file? Just rename the wrong one to adjusted1 or any other name that makes sense and it should work
    Besides you don't need to write Call adjusted as a command - adjusted would be enough.

    Regards

    Theo
    Remember To Do the Following....
    1. Upload sample files
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.

  3. #3
    Registered User
    Join Date
    10-26-2011
    Location
    Virginia
    MS-Off Ver
    Excel 2010
    Posts
    50

    Thumbs up Re: Run different macros based on user response to Input Box?

    Wow, haha guess I messed with the naming at some point fiddling with other issues. Takes a second set of eyes to see some obvious problems I guess. Thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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