| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing the constants in the find function
I am writing a program using the find function in VBA. I would like for the user to be able to chose whether to look in values or formulas (LookIn:=xlValue or xlFormula). When I set a variable = to "xlValue" or xlFormula I get an error message in the find formula. How do you let the user control the LookIn value?
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace - Changing 1st # only | Excel Discussion (Misc queries) | |||
| Find and Replace without changing font | Excel Discussion (Misc queries) | |||
| changing the default type of searching in the find function | Excel Discussion (Misc queries) | |||
| constants | Excel Discussion (Misc queries) | |||
| backwards find function to find character in a string of text | Excel Programming | |||
Threaded Mode
