• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Create Huge Search Button

I have the following code:


[pre]<br />
Sub FIND_SEARCH_BUTTON()<br />
'Opens the find and search dialog box<br />
' Find Search Button Macro<br />
'</p>
<p>On Error Resume Next<br />
Application.Dialogs(xlDialogFormulaFind).Show sFindMe<br />
On Error Resume Next</p>
<p> End Sub<br />
[/pre]


It basically pops open the default search and find dialog box.


I would like to make some sort of pop up form field button that is super large that pops up in the center of the screen and enables me to type in what I' m searching for and click the 'search' the same way.


Having the result found row highlighted would be a bonus.
 
Indi


Odd request


What's wrong with Ctrl F ?

or

Have a cell in your worksheet where people can enter a search query with a simple macro button

or

For probably the best search article I've yet seen

http://www.excelhero.com/blog/2010/07/excel-partial-match-database-lookup.html
 
CTRL+F is fine.


But in a hurry I just wanted a text field I could click my cursor into fast without worrying about clicking on anything else.


Pressing control F, and then zero'ing in on a small text field is kind of...


Well in any case, the post you provided was the ultimate search article I could possibly ask for and it answered my question a million times over.


Thanks again Hui.


I'm using the xls file posted from that article now, it works fantastic.
 
Back
Top