| 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?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
changing the constants in the find function
xlValues and xlFormulas are actually numbers, constants, not strings. They
belong to the xlFindLookIn enumeration, and their actual values a ?xlFindLookIn.xlValues, xlFindLookIn.xlFormulas -4163 -4123 -- Regards Juan Pablo González "OkieViking" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
changing the constants in the find function
You can find the numbers like this
Alt-F11 Ctrl-G to display the Immediate window Enter this and press Enter ? xlFormulas You get the number -4123 Or Juan his example ?xlFindLookIn.xlValues, xlFindLookIn.xlFormulas -4163 -4123 -- Regards Ron de Bruin http://www.rondebruin.nl "Juan Pablo González" wrote in message ... xlValues and xlFormulas are actually numbers, constants, not strings. They belong to the xlFindLookIn enumeration, and their actual values a ?xlFindLookIn.xlValues, xlFindLookIn.xlFormulas -4163 -4123 -- Regards Juan Pablo González "OkieViking" wrote in message ... 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? |
| Reply |
| 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 | |||
Linear Mode
