Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation List Question, Text in Cell DIffers to that Selected | Excel Worksheet Functions | |||
change the data validation to 'any value if 'other' is selected | Excel Discussion (Misc queries) | |||
data validation list selected from a range | Excel Discussion (Misc queries) | |||
monitor cell that uses data validation list for change | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) |