Hi Howard,

Am Thu, 17 Oct 2013 17:22:04 -0700 (PDT) schrieb :

Would you mind having a look at what I've got so far. Once I started fleshing this out it seems to have grown into a small monster.

the materials and diameters are adapted except all GRPSN materials
because I don't get them sorted. You have to add another character or
number to the data table that the different values can be recognized.


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

the materials and diameters are adapted except all GRPSN materials

because I don't get them sorted. You have to add another character or

number to the data table that the different values can be recognized.


Regards

Claus B.

Looking very nice. I'll get after finishing it now that I have some solid and proper code to look as example.

But how will you Excel or VBA tell what is str25GRPSN300 or
str50GRPSN300. I guess you have to change the values for that material
into the data table.

So I need to go to the worksheet list and do something like:

For the 300 Dia.
GRP SN 2500 STIS-30
GRP SN 2500 STIS-30

For the 350 Dia.
GRP SN 2500 STIS-35
GRP SN 2500 STIS-35

And so on.

Thanks for the additional direction.

Howard

Hi Howard,

Am Fri, 18 Oct 2013 10:09:10 -0700 (PDT) schrieb :

For the 300 Dia.
GRP SN 2500 STIS-30
GRP SN 2500 STIS-30

you have e.g.
str25GRPSN350
str50GRPSN350
str10GRPSN350

so you have to add 25, 50 and 10 to the diamters 300, 350, 400, 450 and
500
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

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

Typo

End Sub is highlighted with the error message.

H'wd

Hi Howard,

Am Fri, 18 Oct 2013 23:12:26 -0700 (PDT) schrieb :

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.

you deleted a END SELECT and didn't initialize GRP SN 10000 STIS.
So you ran into an error and the code stopped working. That is why the
returned value was wrong.
For me it is working
Have a look:
https://skydrive.live.com/#cid=9378A...121822A3%21326
for the workbook "DropDown"


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

you deleted a END SELECT and didn't initialize GRP SN 10000 STIS.

So you ran into an error and the code stopped working. That is why the

returned value was wrong.

For me it is working

Have a look:

https://skydrive.live.com/#cid=9378A...121822A3%21326

for the workbook "DropDown"

Regards

Claus B.



Great, thanks Claus.

A little clean up and I hope its done.

Howard