View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] lhkittle@comcast.net is offline
external usenet poster
 
Posts: 168
Default Drop Downs, Index Match or what?



All not needed strings in declaration part can be deleted.


Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2


Hi Claus,

I have made some progress, got all materials to work to a degree, including the pesky

GRP SN 2500 STIS
GRP SN 5000 STIS
GRP SN 10000 STIS

I was checking accuracy of the returns starting with cell A1 and selected uPVC
and 50 in the drop down in B1 and C1 only displays Class 6 and Class 9. It should offer

Class 4
Class 6
Class 9
Class 12
Class 16

for uPVC and 50.

I tried other drop col A downs for no apparent reason to see if there was any differences and bing out of the blue I start getting an error message in the
Select Case - No select case with end case or such and the End Sum is blue highlighted.

I parsed it to the best of my knowledge and cannot find a reason for the error message or why all the classes are not displayed in the C1 drop down.

I am un sure which strings can be deleted as you mention here.
All not needed strings in declaration part can be deleted.


Here is a link, if you care to take a look.
https://www.dropbox.com/s/92isw0vozs...rop%20Box.xlsm


Thanks.
Howard