• 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

indi visual

New Member
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.
 

Hui

Excel Ninja
Staff member
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
 

indi visual

New Member
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.
 
Top