| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| flexible drop-down bars | Excel Discussion (Misc queries) | |||
| I NEED A FLEXIBLE FORMULA | Excel Worksheet Functions | |||
| Can I make formulas more flexible? | Excel Discussion (Misc queries) | |||
| Flexible Cell Reference | Excel Discussion (Misc queries) | |||
| Flexible Charts | Charts and Charting in Excel | |||
Linear Mode
