View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
a m spock a m spock is offline
external usenet poster
 
Posts: 50
Default Enter date via pop-up calendar

This is superb. Having done it, how do I call the calendar from within a data
entry macro, select the date and then carry on with other data entry.

"Ron de Bruin" wrote:

Try this Olivier
http://www.rondebruin.nl/calendar.htm

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


"Olivier" wrote in message ...
How can I provide the user with a 'calender pop-up' as in Outlook, where
(s)he can easily select and enter a valid date in a worksheet cell ?

I assume I don't have to create this pop-up from scratch in Excel, as it is
available in Outlook.
Once defined, I would add this function/routine on right_click_mouse event