Search button in a speadsheet

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

Do you know anythiong about macro programming? Be more specific about the
search and I will help

 

[Guest]

Thanks. I do not know macro programming. Search button should open a page
with a textbox where user will type in the search field and press ok button.
then it will hilight the row with that search field.
Or do you have any better search idea?

 

[Guest]

Typing Cntl F and using the excel build in search is probaly the best way for
you to proceed. The Find All option is nice. It brings up all the items
found and puts them into the Find window. I use this feature alot.

 

[Guest]

Yes, I know about the ctrl-f. The spreadsheet has three tabs and there are
170,000 rows of data altogether. It will be easy for the user to have some
kind of search button to look for what they want. Ctrl-f is a great tool,
but the user has to go to each tab to search for that specific field.
What do you think? Thanks for all your input.

 

[Gord Dibben]

User can search the entire workbook, not just one sheet at a time.

See under CTRL +f and options to search workbook.


Gord Dibben MS Excel MVP