Test plus date and time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent drop down dynamic range formula, off sheet. 7
Excel Lists 4
Formatted cell column in drop down list 1
text plus date and time 2
Created invoices in Excel - not working in Drive 1
customize drop-down box 1
Data validation dependant drop down on unsorted list 6
Drop Down with dynamic named range offsheet source list 14

Back
Top