09-30-2003, 10:49 AM
|
 |
Variable not defined
Retired Moderator
* Guru *
|
|
Join Date: Apr 2002
Location: Ottawa, Ontario
Posts: 4,793
|
|
You'd use the Dialogs collection after selecting the range to search.
Code:
Private Sub CommandButton1_Click()
'To search all sheets use
'Application.Sheets.Select
'To search only active sheet
Application.Cells.Select
Application.Dialogs(xlDialogFormulaFind).Show
End Sub
|
__________________
-Carl
|
Find...
Linear Mode
