The built in Find command does this

you can display that dialog with

Private Sub CommandButton1_Click()
Columns(2).Select
application.Dialogs(xlDialogFormulaFind).Show
End Sub

or just use the shortcut key Ctrl+F

Yes, you can use wildcards.

If it finds the target, it will select the cell.
--
Regards,
Tom Ogilvy

"Al" wrote in message
...
I have not coded in Excel before but have done some in
Access. I recently received a request to do the following:

In an Excel 2000 spreadsheet, I would like to be able to
press a command button, bring up a textbox that asks the
user for part of a search string for column "B" (can it
use wildcards?), and finally, go to the row where the
searched value exists.

TIA,
Al