In my Excel project, I like to provide this control so that user can choose
hrs and min to transfer to worksheet or a form.

how do I get this control and use it. i these discussions it is possible
and people are using in VBA.

your help, suggestions or sample code will help.

Thank you
MVM

Hi MVM

See
http://msdn.microsoft.com/library/de...me/reflist.asp

Set Custom to 3 - dtpCustom and CustomFormat to h:mm to display time
And Updown to True in the properties





--
Regards Ron De Bruin
http://www.rondebruin.nl



"MVM" wrote in message ...
In my Excel project, I like to provide this control so that user can choose
hrs and min to transfer to worksheet or a form.

how do I get this control and use it. i these discussions it is possible
and people are using in VBA.

your help, suggestions or sample code will help.

Thank you
MVM

Ron:
Thanks a lot. That works.
MVM

"Ron de Bruin" wrote:

Hi MVM

See
http://msdn.microsoft.com/library/de...me/reflist.asp

Set Custom to 3 - dtpCustom and CustomFormat to h:mm to display time
And Updown to True in the properties





--
Regards Ron De Bruin
http://www.rondebruin.nl



"MVM" wrote in message ...
In my Excel project, I like to provide this control so that user can choose
hrs and min to transfer to worksheet or a form.

how do I get this control and use it. i these discussions it is possible
and people are using in VBA.

your help, suggestions or sample code will help.

Thank you
MVM

I got the DTPicker control and did some programming.

I placed one in each of the two Spreadsheets and one on a form.
when i invoke the picker, it display the control at some position. When I
click on a different cell, it is supposted to be around the cell. It does
that (call it pk-1). But also opens another copy at the location when it
first came in (pk-2). Only this one is real. otherone is not real. with
pk-1 i just can't do any thing. when I click on pk-2, pk-1 disappears.

I used LostFocus to move the date and time to the cells. What i noticed is,
when I invoke the control, it won't get the focus. I tried Activate etc.
How do I high light the hours or minutes as soon as it appears. This also
solves the above problem. If I can get the focus for pk-2 programmatically,
pk-1 will disappear.

Any suggestions - highly appreciated.

Also where Can i find the discriptions of the picker fields. In properties
box I see position, hour and minute. But in Object Browser I don't see these.

Thanks
MVM

"Ron de Bruin" wrote:

Hi MVM

See
http://msdn.microsoft.com/library/de...me/reflist.asp

Set Custom to 3 - dtpCustom and CustomFormat to h:mm to display time
And Updown to True in the properties





--
Regards Ron De Bruin
http://www.rondebruin.nl



"MVM" wrote in message ...
In my Excel project, I like to provide this control so that user can choose
hrs and min to transfer to worksheet or a form.

how do I get this control and use it. i these discussions it is possible
and people are using in VBA.

your help, suggestions or sample code will help.

Thank you
MVM

One more observation:
When I go on debug mode - it perfectly places the control. I don't see two
images. I am viewing the excel sheet and the codesheet simultaneously. But
if I run without the debug mode I see two controls. one at the original
position and it is active and the other at the place I want (top and left are
changed based on the target cell). This is not active and disappears as soon
as i click on the first one.
Thanks
MVM

"MVM" wrote:

I got the DTPicker control and did some programming.

I placed one in each of the two Spreadsheets and one on a form.
when i invoke the picker, it display the control at some position. When I
click on a different cell, it is supposted to be around the cell. It does
that (call it pk-1). But also opens another copy at the location when it
first came in (pk-2). Only this one is real. otherone is not real. with
pk-1 i just can't do any thing. when I click on pk-2, pk-1 disappears.

I used LostFocus to move the date and time to the cells. What i noticed is,
when I invoke the control, it won't get the focus. I tried Activate etc.
How do I high light the hours or minutes as soon as it appears. This also
solves the above problem. If I can get the focus for pk-2 programmatically,
pk-1 will disappear.

Any suggestions - highly appreciated.

Also where Can i find the discriptions of the picker fields. In properties
box I see position, hour and minute. But in Object Browser I don't see these.

Thanks
MVM

"Ron de Bruin" wrote:

Hi MVM

See
http://msdn.microsoft.com/library/de...me/reflist.asp

Set Custom to 3 - dtpCustom and CustomFormat to h:mm to display time
And Updown to True in the properties





--
Regards Ron De Bruin
http://www.rondebruin.nl



"MVM" wrote in message ...
In my Excel project, I like to provide this control so that user can choose
hrs and min to transfer to worksheet or a form.

how do I get this control and use it. i these discussions it is possible
and people are using in VBA.

your help, suggestions or sample code will help.

Thank you
MVM

Hi MVM

Is your zoom 100% ?

Bed time here so I reply tomorrow

--
Regards Ron De Bruin
http://www.rondebruin.nl



"MVM" wrote in message ...
One more observation:
When I go on debug mode - it perfectly places the control. I don't see two
images. I am viewing the excel sheet and the codesheet simultaneously. But
if I run without the debug mode I see two controls. one at the original
position and it is active and the other at the place I want (top and left are
changed based on the target cell). This is not active and disappears as soon
as i click on the first one.
Thanks
MVM

"MVM" wrote:

I got the DTPicker control and did some programming.

I placed one in each of the two Spreadsheets and one on a form.
when i invoke the picker, it display the control at some position. When I
click on a different cell, it is supposted to be around the cell. It does
that (call it pk-1). But also opens another copy at the location when it
first came in (pk-2). Only this one is real. otherone is not real. with
pk-1 i just can't do any thing. when I click on pk-2, pk-1 disappears.

I used LostFocus to move the date and time to the cells. What i noticed is,
when I invoke the control, it won't get the focus. I tried Activate etc.
How do I high light the hours or minutes as soon as it appears. This also
solves the above problem. If I can get the focus for pk-2 programmatically,
pk-1 will disappear.

Any suggestions - highly appreciated.

Also where Can i find the discriptions of the picker fields. In properties
box I see position, hour and minute. But in Object Browser I don't see these.

Thanks
MVM

"Ron de Bruin" wrote:

Hi MVM

See
http://msdn.microsoft.com/library/de...me/reflist.asp

Set Custom to 3 - dtpCustom and CustomFormat to h:mm to display time
And Updown to True in the properties





--
Regards Ron De Bruin
http://www.rondebruin.nl



"MVM" wrote in message ...
In my Excel project, I like to provide this control so that user can choose
hrs and min to transfer to worksheet or a form.

how do I get this control and use it. i these discussions it is possible
and people are using in VBA.

your help, suggestions or sample code will help.

Thank you
MVM

yes my excel is 100% zoomed.

thank you
MVM

"Ron de Bruin" wrote:

Hi MVM

Is your zoom 100% ?

Bed time here so I reply tomorrow

--
Regards Ron De Bruin
http://www.rondebruin.nl



"MVM" wrote in message ...
One more observation:
When I go on debug mode - it perfectly places the control. I don't see two
images. I am viewing the excel sheet and the codesheet simultaneously. But
if I run without the debug mode I see two controls. one at the original
position and it is active and the other at the place I want (top and left are
changed based on the target cell). This is not active and disappears as soon
as i click on the first one.
Thanks
MVM

"MVM" wrote:

I got the DTPicker control and did some programming.

I placed one in each of the two Spreadsheets and one on a form.
when i invoke the picker, it display the control at some position. When I
click on a different cell, it is supposted to be around the cell. It does
that (call it pk-1). But also opens another copy at the location when it
first came in (pk-2). Only this one is real. otherone is not real. with
pk-1 i just can't do any thing. when I click on pk-2, pk-1 disappears.

I used LostFocus to move the date and time to the cells. What i noticed is,
when I invoke the control, it won't get the focus. I tried Activate etc.
How do I high light the hours or minutes as soon as it appears. This also
solves the above problem. If I can get the focus for pk-2 programmatically,
pk-1 will disappear.

Any suggestions - highly appreciated.

Also where Can i find the discriptions of the picker fields. In properties
box I see position, hour and minute. But in Object Browser I don't see these.

Thanks
MVM

"Ron de Bruin" wrote:

Hi MVM

See
http://msdn.microsoft.com/library/de...me/reflist.asp

Set Custom to 3 - dtpCustom and CustomFormat to h:mm to display time
And Updown to True in the properties





--
Regards Ron De Bruin
http://www.rondebruin.nl



"MVM" wrote in message ...
In my Excel project, I like to provide this control so that user can choose
hrs and min to transfer to worksheet or a form.

how do I get this control and use it. i these discussions it is possible
and people are using in VBA.

your help, suggestions or sample code will help.

Thank you
MVM

I believe that the Date and Time Picker comes with Visual Studio, and not MS
Office. The calendar control that comes with office is the Calendar Control
11.0(?), and that is inserted into a workbook from the Control ToolBox
Toolbar.
--
Kevin Backmann


"MVM" wrote:

In my Excel project, I like to provide this control so that user can choose
hrs and min to transfer to worksheet or a form.

how do I get this control and use it. i these discussions it is possible
and people are using in VBA.

your help, suggestions or sample code will help.

Thank you
MVM