David wrote in message ...
Yvon wrote
Hello,
I have a big spreadsheet with a database and want to make the search
feature (CNTRL F)user friendly by adding a "button" to enable this.
Unfortunately when creating the macro you cannot stop recording unless
you enter data into the search or either close it which obviously
renders the "button" useless. I am not familiar with VBA and therefore
must do so through the macro recording. Any ideas???
A quick Google search turned up this from Tom Ogilvy:
-------
Tom Ogilvy Jan 13 2000, 12:00 am show options
Newsgroups: microsoft.public.excel.worksheet.functions
From: "Tom Ogilvy" - Find messages by this author
Date: 2000/01/13
Subject: 2 questions
Reply to Author | Forward | Print | Individual Message | Show original |
Report Abuse
Put this macro in a general module in the VBE
Sub Button1_click()
Application.Dialogs(xlDialogFormulaFind).Show
End Sub
Get a button from the forms toolbar and put it on the sheet. Right click
on
it and choose assign macro. Assign the above macro.
-------
Almost works....i have created a button with the VBA code as
instructed and lo and behold it does display the find dialoq box yet
won't return the value searching for even though it is right there in
the spreadsheet...is something missing????
Yvon
|