Thanks so much for your info, but I have no idea how to attach this macro to
the search button.
--
thadi


"Joel" wrote:

You can do finds using the Edit Menu - Find using shortcut Key Cntl F. You
can setup your own shortcut keys after a macro is written by go to Tools Menu
- Macro - Macros. Then selecting Options.

A button can be added to the worksheet to call a macro. go to view Menu -
toolsbars - Control toolbar. Add Commandbutton to worksheet. Then double
click button. VBA window will appear where you can add macro instructions.

for beginner, you can perform a learn macro (tools Menu - Macro) and record
the command you use when doing the search manually. Then insert macro into
the command button click macro.

"Tasmania" wrote:

Hi. I want to put search button in a Excel spreadsheet. I recently started
Excel. I am a Access user. Does anyone have any clue? Any suggestion will
be greatly appreciated.
--
thadi