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" <(E-Mail Removed)> wrote in message news:2e2f8c06-9489-4b62-9f45-(E-Mail Removed)...
> 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" <rondebr...@kabelfoon.nl> wrote:
> Maybe you like thishttp://www.rondebruin.nl/calendar.htm
>
> --
>
> Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
>
>
>
> "K" <kamranr1...@yahoo.co.uk> wrote in messagenews:2e2f8c06-9489-4b62-9f45-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message news:bdf5ca68-d0f9-43a1-8c7e-(E-Mail Removed)...
On 11 Dec, 21:05, "Ron de Bruin" <rondebr...@kabelfoon.nl> wrote:
> Maybe you like thishttp://www.rondebruin.nl/calendar.htm
>
> --
>
> Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
>
>
>
> "K" <kamranr1...@yahoo.co.uk> wrote in messagenews:2e2f8c06-9489-4b62-9f45-(E-Mail Removed)...
> > 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" <rondebr...@kabelfoon.nl> 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" <kamranr1...@yahoo.co.uk> wrote in messagenews:bdf5ca68-d0f9-43a1-8c7e-(E-Mail Removed)...
>
> On 11 Dec, 21:05, "Ron de Bruin" <rondebr...@kabelfoon.nl> wrote:
>
> > Maybe you like thishttp://www.rondebruin.nl/calendar.htm
>
> > --
>
> > Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
>
> > "K" <kamranr1...@yahoo.co.uk> wrote in messagenews:2e2f8c06-9489-4b62-9f45-(E-Mail Removed)...
> > > 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" <rondebr...@kabelfoon.nl> 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" <kamranr1...@yahoo.co.uk> wrote in messagenews:bdf5ca68-d0f9-43a1-8c7e-(E-Mail Removed)...
>
> On 11 Dec, 21:05, "Ron de Bruin" <rondebr...@kabelfoon.nl> wrote:
>
> > Maybe you like thishttp://www.rondebruin.nl/calendar.htm
>
> > --
>
> > Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm
>
> > "K" <kamranr1...@yahoo.co.uk> wrote in messagenews:2e2f8c06-9489-4b62-9f45-(E-Mail Removed)...
> > > 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