Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generate date in cell on changing value in drop down list
Hi there,
I would need some support please on how to program in VBA the following task: In column M of any row the user chooses in a drop down list (values 1 to 6) one value, at which simultaneously the current date (of selection) is copied into column N to S of the same row. E.g.: User selects value 1 of drop down list in M3 so the date of today e.g. 08/20/08 is copied into N3. At the 08/25/08 the user selects value 2 in M3 so the date is copied into O3. At the 08/29/08 the user selects value 3 in M3 so the date is copied into P3. And so on. Maximum of the date history would be S3 as there are 6 values to select. This should work for all rows whereas the columns stay the same. Many thanks for any support. Hannes |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do generate a drop down list with no blanks | Excel Discussion (Misc queries) | |||
drop-down list changing according to choice made | Excel Programming | |||
drop-down list changing according to choice made | Excel Worksheet Functions | |||
changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
changing the font size on the drop down of a list (autofilter). | Excel Programming |