View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default 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.