Case statement based on value within drop-down box

[aaron.irvine]

Hey guys,

I'm trying to run a Case statement that will check the value of a cell that contains a drop down box, and then either hide or unhide a specific row based on the result. I'm having all-sorts of trouble with it, and I'm sure it's pretty straight forward!

H7:H16 is a range that contains a drop-down box where users select a string value representing a volumetric size.

Please Login or Register  to view this content.

I'm not even sure I'm supposed to put it in the Worksheet_Change Sub, or if half the lines of code I've got in there are even relevant. I ripped the code from another Case statement that actually works, but which relied on data entry to the cell, not drop-down boxes.

I'm sure I've made a complete hash of it! Sorry for the mess.....

[millz]

Your drop down box is spread across 10 cells? Select Case can only look at 1 value at a time.

[aaron.irvine]

No, sorry for the confusion.

The drop-down box is contained in one cell, but that drop-down box is replicated across that cell range. I really only need it to work on cell cell H7, but if I can cover the entire range of data entry points it would cover the error trapping issues I may encounter!

[millz]

Then try changing the select case statement to

Please Login or Register  to view this content.

[aaron.irvine]

I dumbed it down, converted the strings to integers in the drop-down box and used If statements.

I'd prefer Case statements so I could integrate them in other spreadsheets down the track, but this is working for me!

Please Login or Register  to view this content.