flexible find

S

stan

I'm looking for VBA that will
1. copy a cell value into the clipboard
2. call the search dialog box and
3. paste the clipboard entry into the dialog box
 
D

Dave Peterson

You don't need to do that much work:

Application.Dialogs(xlDialogFormulaFind).Show arg1:=ActiveCell.Value
 
Top