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

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

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

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

"Tasmania" wrote:

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

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?
--
thadi


"Joel" wrote:

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

"Tasmania" wrote:

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

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.

"Tasmania" wrote:

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?
--
thadi


"Joel" wrote:

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

"Tasmania" wrote:

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