View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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