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