Using DTPicker to change date in a cell when user selects cell?
 

On a normal excel spreadsheet I would like to be able to have a cell which
holds a date, by default the current date. When the user clicks on the cell
the Date Time Picker calendar control pops up allowing the user to select a
new date which then replaces the date already in the cell. Anyone have an
idea of how to accomplish this? Thanks.

Using DTPicker to change date in a cell when user selects cell?
 

I should clarify that I am setting up a sheet that would have hundreds of
such cells on it, if that makes a difference in how this might be
approached.

Using DTPicker to change date in a cell when user selects cell?
 

Hi WaterDog

See
http://www.rondebruin.nl/calendar.htm

--
Regards Ron De Bruin
http://www.rondebruin.nl



"WaterDog" wrote in message ...
On a normal excel spreadsheet I would like to be able to have a cell which holds a date, by default the current date. When the
user clicks on the cell the Date Time Picker calendar control pops up allowing the user to select a new date which then replaces
the date already in the cell. Anyone have an idea of how to accomplish this? Thanks.

Using DTPicker to change date in a cell when user selects cell?
 

Thank you! That was exactly what I was looking for. It works great.


"Ron de Bruin" wrote in message
...
Hi WaterDog

See
http://www.rondebruin.nl/calendar.htm

--
Regards Ron De Bruin
http://www.rondebruin.nl



"WaterDog" wrote in message
...
On a normal excel spreadsheet I would like to be able to have a cell
which holds a date, by default the current date. When the user clicks on
the cell the Date Time Picker calendar control pops up allowing the user
to select a new date which then replaces the date already in the cell.
Anyone have an idea of how to accomplish this? Thanks.