Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation list driving macros
Hi,
I have a column in a sheet each cell of which is populated from a validation drop-down. The values of each cell are independent of each other, but are selected from the same range of options. What I would like to do is associate a macro with each validation option to generate a different output per line according to what is selected in the drop-down. Eg - Column B is the validation, offering a choice of multiply by two or add two. The macro output is produced in column C: A B C data 1 *2 2*(data 1) data 2 +2 2+(data 2) data 3 +2 2+(data 3) data 3 *2 2*(data 3) Any solutions would be much appreciated. TIA Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation list driving macros
I'm not sure you need a macro for this
C2: =IF(B2="*2",2*A2,IF(B2="+2",2+A2)) -- HTH, Barb Reinhardt "Risky Dave" wrote: Hi, I have a column in a sheet each cell of which is populated from a validation drop-down. The values of each cell are independent of each other, but are selected from the same range of options. What I would like to do is associate a macro with each validation option to generate a different output per line according to what is selected in the drop-down. Eg - Column B is the validation, offering a choice of multiply by two or add two. The macro output is produced in column C: A B C data 1 *2 2*(data 1) data 2 +2 2+(data 2) data 3 +2 2+(data 3) data 3 *2 2*(data 3) Any solutions would be much appreciated. TIA Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming | |||
Validation (Drop down list vs simple text length validation) | Excel Programming |