Consulting

Results 1 to 7 of 7

Thread: Solved: User Input With Options

  1. #1
    VBAX Expert
    Joined
    Feb 2010
    Posts
    696
    Location

    Solved: User Input With Options

    Attached is a small sample of a worksheet that contains English words in column A and Creek words in column B.

    I need a script to ask for user input that allows the user to choose between English and Creek. (I'm thinking either radio or check buttons?) If English is selected, then search the terms in column A (all terms below the heading). If Creek is selected, then search the terms in column B (all terms below the heading).

    The list of terms in each column is expandable so the search needs to be able to accommodate an expanded range. Any help will be appreciated.

    Thanks,

    Opv
    Last edited by Opv; 06-15-2010 at 12:29 PM.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    How are you going to run it? If you have a userform, a radio button is simple, and you can have a textbox for input. But what are they searching for, you don't say?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Expert
    Joined
    Feb 2010
    Posts
    696
    Location
    Quote Originally Posted by xld
    How are you going to run it? If you have a userform, a radio button is simple, and you can have a textbox for input. But what are they searching for, you don't say?
    I am thinking about a command button the user can click on to "Search" the terms. I was initially thinking when the button is clicked that a dialog box would pop up and request the input (they would select either Creek or English and then type the search term in a text field). The term entered in the search field would then be used to search within the respective range (either the terms in column A if it's English is selected or those in column B if Creek is selected).

    Does that make sense?

    Thanks

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    NOt really. If they input the value, what exactly will the search return?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    VBAX Expert
    Joined
    Feb 2010
    Posts
    696
    Location
    I think I've solved my problem with a user form. Thanks.
    Last edited by Opv; 06-15-2010 at 12:28 PM.

  6. #6
    VBAX Regular
    Joined
    Jun 2010
    Posts
    27
    Location
    Which user forum did you use? I'd like to know how you made this work.

  7. #7
    VBAX Expert
    Joined
    Feb 2010
    Posts
    696
    Location
    Quote Originally Posted by zaboo9
    Which user forum did you use? I'd like to know how you made this work.
    It wasn't a user forum, it was a "user form". I just created a user form.

Posting Permissions

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