on error message

[manforeyes]

Hi all

Yet another post, hopefully I can explain this right.

1 I have a textbox with three different search criteria first one Name: second login name and third extension. I have three different vlookup depending on what option button they selected, I'd like to remove the option buttons. example I enter a name say Pete Peterson than vlookup that criteria login say chpi than vlookup that if extension than vlookup that. I am starting to think of a select case but how?

[rylo]

Hi

How could you determine from the input which criteria is being entered? Or would you have a checkbox to determine which item is being entered, and a textbox to get the data?

rylo