Thread: changing the constants in the find function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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 With QuoteReply With Quote