Search button in a speadsheet
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
|