flexible find

[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

 

[Dave Peterson]

You don't need to do that much work:

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

 

[Dave Peterson]

And if you really want a more flexible find, try Jan Karel Pieterse's FlexFind:
http://www.jkp-ads.com/OfficeMarketPlaceFF-EN.asp

 

[stan]

thanks-works perfectly
--
stan

And if you really want a more flexible find, try Jan Karel Pieterse's FlexFind:
http://www.jkp-ads.com/OfficeMarketPlaceFF-EN.asp