You don't need to do that much work:

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



stan wrote:

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
--
stan

--

Dave Peterson