changing the constants in the find function

[Guest]

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?

 

[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

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?

 

[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