Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 make 1 date cell automatically change another date cell | Excel Worksheet Functions | |||
Automatically change cell colors based on date in cell | Excel Discussion (Misc queries) | |||
Cell click on one cell selects 2 or 3 cells? | Excel Worksheet Functions | |||
How can i change cell colour depending on month of date in cell? | Excel Discussion (Misc queries) | |||
Excel 2003 - Ctrl-End selects last cell. How chg last cell addr? | Excel Worksheet Functions |