Add drop down list to cell dependent on value of other cell

Hi Guys,

I am trying to edit a worksheet so that when you select certain values in cell D5 it will give you a dropdown box in E5 and if you select other values then it will simply give you the value "N/A"

Through some googling it looked like the only way to do this was with a macro and what I have is here:

Please Login or Register  to view this content.

However when I run this it does absolutely nothing..........

Any help would be greatly appreciated!

I have attached the sheet if its helpful and it is on the worksheet "Circuit Breakers"

Thanks!

Tom

2 things that you need to do when you edit this post..

1. Put your code in code tags by highlighting it and pressing the # button.
2. Actually attach that workbook that you said you did