I have a list of names and I want to put those names in a drop down list.
Once someone selects a name from the drop down list I want that name and the
current date and time to populate that cell. Does anyone have any
suggestions?
I have a list of names and I want to put those names in a drop down list.
Once someone selects a name from the drop down list I want that name and the
current date and time to populate that cell. Does anyone have any
suggestions?
See
http://www.mcgimpsey.com/excel/timestamp.html
If you're using XL02/03 you can combine the macro with Data/Validation
dropdowns. If you're using XL97/00(IIRC) or MacXL, you'll need to use
the Worksheet_Calculate event instead, since choosing a value from a
validation dropdown doesn't fire the _Change event.
In article <[email protected]>,
"Kelly" <[email protected]> wrote:
> I have a list of names and I want to put those names in a drop down list.
> Once someone selects a name from the drop down list I want that name and the
> current date and time to populate that cell. Does anyone have any
> suggestions?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks