Microsoft Date and Time Picker control

M

Michelle Hillard

Hi guys,
I have a date column in column A, with 4 columns in total.
For every new row in this column, I would like to automatically select a
date from a MS Date and Time Picker control.
Once the date is selected, I would like the control to hide (or unload
whatever is better practice), and the date displayed in the cell in format
dd/mm/yyyy.
If I want to change the date, I would like the control to once again be
present, then go when selected.
Instead of copying the control to the whole column, I wanted to somehow have
it load when I start a new record, the trigger being entering text into
column B.
Is this possible?

Any help greatly appreciated.


--


---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"

Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com
 
N

Nikos Yannacopoulos

Michelle,

Adding a DTPicker to each and every line is definitely not
the way to go, as you guessed! Alternatively, I would
suggest you use a form to hook the DTPicker on, and add a
button to paste the selected date to the currently active
cell.
As far as triggering goes, to the best of my knowledge
Excel has events only for an entire worksheet, not for
ranges (e.g. column B). If you go with the form /
activecell option, though, you can leave the form open as
long as you work with your workbook, which should be a
rather acceptable altarnative to what you had in mind, I
hope...

HTH,
Nikos
 

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

Top