Thread: changing the constants in the find function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Juan Pablo González Juan Pablo González is offline
external usenet poster
  
Posts: 226
Default 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?


Reply With QuoteReply With Quote