Thread: changing the constants in the find function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
OkieViking OkieViking is offline
external usenet poster
  
Posts: 37
Default 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?
Reply With QuoteReply With Quote