changing the constants in the find function

O

OkieViking

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?
 
J

Juan Pablo González

xlValues and xlFormulas are actually numbers, constants, not strings. They
belong to the xlFindLookIn enumeration, and their actual values are:

?xlFindLookIn.xlValues, xlFindLookIn.xlFormulas
-4163 -4123

--
Regards

Juan Pablo González

OkieViking said:
I am writing a program using the find function in VBA. I would like for
Click to expand...
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?
 
R

Ron de Bruin

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
 
Top