View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default Link control to Excel cell to click a day in month to return date

You may want to check out Ron de Bruin's pop up calendar


Calendar on the page - pop-up version
http://www.rondebruin.nl/calendar.htm



"Janas in RSA" wrote:

I want to link a Control to an Excel cell. When I click the control (e.g.
maybe a square date box or down arrow as in Validate) I want to see at top a
changeable "YEAR" and "MONTH" and below it, by week, the weekdays for "YEAR"
and "MONTH". Once I have selected the "YEAR" and "MONTH" I need, I click a
day of the week and the control must then insert the date (for selected
"DAY", "MONTH" and "YEAR") in the cell that is linked to the control.