Hi, I want to be able to dynamically check which value a user select in
a dropdown list and automatically change the value of another cell.

Also, where in the project should I put the code? Should it be in
"ThisWorkBook" or "SheetSet"?

I am using Excel 2000.

Thanks for any answers.