DTPicker Calander Popup

[K]

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.

 

[Ron de Bruin]

Maybe you like this
http://www.rondebruin.nl/calendar.htm

 

[K]

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

--

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





- 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

 

[Ron de Bruin]

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 Bruin
http://www.rondebruin.nl/tips.htm

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

--

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





- 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

 

[K]

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






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

Thanks for replying Ron. Yes i'll send you the workbook with control
init as soon as possible.

 

[K]

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






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