read value and compare from list in VBA

I need to write an that reads the value from a cell that contains a drop down list. If item1 is selected I need to perform one calculation. if item2 is selected I need to do another, and so on.

Can someone help?

Thank you

hi

If you use validation you can use following code to return index of selected value.
Then you will be able to build Select Case or if, elseif to define what should be calculated

Please Login or Register  to view this content.

Best Regards
MaczaQ

Thanks for you help. I'm sorry, but I am still not sure what to do. Would you mind showing me exactly how I would use the function below?

Thanks.