Find Dialog Box

Topic

New Reply

I have users that do a lot of finding in a selected range. Is itpossible to create a macro that opens the find dialog box and sits and waits for the user to type in the criteria?

Thanks for any help provided!

Itconc

Reply | Quote

Replies

Yes:

Code:

Sub FindIt()
  CommandBars.FindControl(ID:=1849).Execute
End Sub

Reply | Quote

Yes:

Code:

Sub FindIt()
  CommandBars.FindControl(ID:=1849).Execute
End Sub

Reply | Quote

Thank you

Reply | Quote