Solved: User Input With Options

[Opv]

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

[Bob Phillips]

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]

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

[Bob Phillips]

NOt really. If they input the value, what exactly will the search return?

[Opv]

I think I've solved my problem with a user form. Thanks.

[zaboo9]

Which user forum did you use? I'd like to know how you made this work.

[Opv]

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.