On Dec 16, 4:50*pm, "Ron de Bruin" wrote:
Hi K

I not have this control on my machine I believe (Or I am not looking good)
Can you send me a small workbook private with the control I will look at it then for you.

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"K" wrote in ...

On 11 Dec, 21:05, "Ron de Bruin" wrote:

Maybe you like thishttp://www.rondebruin.nl/calendar.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm

"K" wrote in ...
Hi all, I got DTPicker control on my sheet and when I click it then a
little calander pops up. How can I do this by macro like instead of
clicking it can I display DTPicker calander by macro. Please can any
friend can help.- Hide quoted text -

- Show quoted text -

Hi Ron, *Thanks for replying. *Your calender control macro is superb
but i also want to know that how can i SetFocus DTPicker control by
macro. *Like i want macro on a button that when i click that button
then macro should SetFocus the DTPicker control. *Please can you help

Hi Ron, Please see my workbook in link below which i have uploaded.
I have explained everything in it what i am tring to achive.
This is the link for my workbook : http://www.savefile.com/files/1936854