how to monitor the selected value of a Data Validation list
 

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.

how to monitor the selected value of a Data Validation list
 

hi,
not sure what you mean by "check whick value a user select" but getting the
value in a cell is easy.

Private Sub ComboBox1_Change()
Range("F3").Value = ComboBox1.Value
End Sub
put the code in in the combo box. Right click the combo box, click view code.

regards
FSt1

"silkworm" wrote:

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.