Running macros by making a selection in a dropdown list

[blueshift1]

Hello everyone, I'm fairly new to VBA (coming from C++ and FORTRAN) and have created a bit of code to read in data from a drop down list and based on the selection, color a specific row. I've verified all my row coloring routines are functioning properly and so it seems my selection routine must be at fault.

What is occurring is that no matter what value from the list I select, the same routine (repair3) is run (I checked using message boxes). If anyone could help in any way, I'd be quite grateful... because this just doesn't seem to make sense to me.

Please Login or Register  to view this content.

[tigeravatar]

blueshift1,

Welcome to the forum!
Give it a try this way:

Please Login or Register  to view this content.

[blueshift1]

Worked perfectly. Thanks so much!