View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Convert code to lookup three criteria return fourth

Hi Howard,

Am Mon, 14 Oct 2013 13:55:22 -0700 (PDT) schrieb Howard:

str2 is a number, 40, 125, 60 etc. but is accepted as a string from the input box.
The values in the drop down are identical to the values entered into the input boxes...?


for me it works with numbers
But try changing .value to .text


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2