+ Reply to Thread
Results 1 to 3 of 3

display a message, before calling the function

  1. #1
    Registered User
    Join Date
    05-14-2008
    Posts
    27

    display a message, before calling the function

    Hello,

    I have a function as follows:

    Please Login or Register  to view this content.
    Then I have a button that runs this function when it is clicked.

    How can I display a message, before calling the function, to ask the user which value of "n" he or she wants?

    I want to display 3 options:
    "Normal", Value = 1
    "Fast", Value = 2
    "Slow", Value = 3

    How can I do this?

    Thanks,
    Miguel

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431
    Short and sweet

    Please Login or Register  to view this content.
    Or you could build a userform and gather the information via listbox or combobox or textbox or optionbuttons.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Miguel,

    Use an InputBox to ask the user to enter one of the three choices, and use the result as the macro argument. Here is an example...
    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

+ 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