indi visual
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.
[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.