DTPicker Calander Popup

  • Thread starter Thread starter K
  • Start date Start date
K

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.
 
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 -
Click to expand...

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 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
Click to expand...

Thanks for replying Ron. Yes i'll send you the workbook with control
init as soon as possible.
 
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
Click to expand...

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