PDA

View Full Version : Solved: User Input With Options



Opv
06-15-2010, 05:14 AM
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

xld
06-15-2010, 05:19 AM
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?

Opv
06-15-2010, 05:28 AM
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

xld
06-15-2010, 05:33 AM
NOt really. If they input the value, what exactly will the search return?

Opv
06-15-2010, 07:43 AM
I think I've solved my problem with a user form. Thanks.

zaboo9
07-21-2010, 10:50 AM
Which user forum did you use? I'd like to know how you made this work.

Opv
07-21-2010, 10:53 AM
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.