flexible find
 

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

flexible find
 

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

flexible find
 

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

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

flexible find
 

thanks-works perfectly
--
stan


"Dave Peterson" wrote:

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

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