Find Button within excel spreadsheet

Microsoft Excel 2003 (full product)
January 28, 2011 at 07:05:02
Specs: Windows XP
Could anyone tell me how to create a button within my excel spreadsheet that will automatically bring up the "Find" window?

See More: Find Button within excel spreadsheet

January 28, 2011 at 07:50:28
In Excel 2003 you can customize your tool bars and menus by dragging and dropping menu items.

Click Tools...Customize...Commands tab

Click the Edit choice in the left hand pane, then scroll down to Find in the right hand pane.

Drag and drop Find onto any Toolbar at the top of the screen. The binoculars icon will appear.

Close the Customize dialog box.

When you exit Excel, the app will create/update a file called excel.xlb which stores your customized toolbars so Excel opens them whenever you open the app.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

January 28, 2011 at 08:48:49
I am making this spreadsheet for someone who knows nothing about Excel. I was trying not to use menu or toolbar buttons but buttons withing the Excel Spreadsheet itself. I have 2 functions I need to have the spreadsheet perform. The first is a button you would push when you want to run a search withing the data of the worksheet. The other is a button that will automatically bring up the form for manual input of data. Would you be able to help?

Report •

January 28, 2011 at 09:57:49
I don't know enough about Forms to help out with that portion.

There are lots of places on the web that could provide instructions. Google around to see what you can find.

As far as the Find button goes, if I were you, I would include instructions on how to add the Find icon to the toolbar. As I outlined in my previous post, the steps are quite simple. If the user can't pull down a menu and drag and drop an icon, well, what can I say.

Can they press Ctrl-f? That will bring up the Find box.

If you really want to add a custom button, then you'll need a Macro. You'll also need to make sure that Macros are enabled on any machine that will use this button. If they are not enabled, then you'll need to provide instructions to the user as to how to enable Macros. If they are able to follow those instructions, then they should be able to follow the instructions to add the Find icon to a toolbar, which would then be available in any and all spreadsheets they open. You'd be doing the user a big service by teaching them something new while making the Find icon available whenever they need it.

All that said, here's your button:

1 - Press Alt-F11 to open the VBA editor.
2 - Click Insert...Module
3 - Paste the following code into the pane that opens.

Sub MyFind()
End Sub

3 - Close the VBA editor
4 - Create a shape in your workbook or on your form.
5 - Right Click and choose Assign Macro.
6 - Locate MyFind in the list and double-click
7 - Back in the spreadsheet, click anywhere to deselect the shape
8 - Mouse-over the shape and the cursor should become a link-finger.
9 - Click the shape

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

June 23, 2011 at 06:11:45
Hi Debydad03,

I have kindergarden experience when it comes to writing code, and I love the simple code required for "Find" feature.

I have a similar query. I need to have the "user input" a search within the spreadsheet and highlight all of the duplictes for quick access and then remove the highlights for future searches.

Can you help me with that?

Report •

June 23, 2011 at 06:30:38
Since your question is not really related the question in this thread, please post your question in it's own thread with a relevant subject line.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

September 20, 2011 at 09:30:55
To make the binoculars icon appear in the Standard Toolbar do the following:
Highlight Standard Toolbar
Open Commands Tab
Find the Binoculars Icon
Drag the Icon to the Standard Toolbar above the Desktop.

Report •

Ask Question