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.

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"K" wrote in message ...
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.

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 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


"K" wrote in message ...
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

On 16 Dec, 16:50, "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

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

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