Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/Time Picker
I don't have the DTPicker control in my control toolbox. I looked in the
"additional controls" and only saw the "calendar" control. Where do I find the DTPicker control? Thanx in advance for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/Time Picker
Assuming in the VBE editing a userform:
did you do Additional Controls in Tools=Additional controls (A userform should have the focus) In the workbook, click the other controls button at the bottom of the control toolbox toolbar (the crossed tools icon). -- Regards, Tom Ogilvy "Obie" wrote in message ... I don't have the DTPicker control in my control toolbox. I looked in the "additional controls" and only saw the "calendar" control. Where do I find the DTPicker control? Thanx in advance for your help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/Time Picker
Read Chip Pearson's note's
The DTPicker (Date Time Picker) control is distributed with the Visual Studio applications (Visual Basic (not VBA), Visual C++, etc), not with Office/VBA. You will have to purchase a VS or VSNET application. -- Regards Ron de Bruin http://www.rondebruin.nl "Obie" wrote in message ... I don't have the DTPicker control in my control toolbox. I looked in the "additional controls" and only saw the "calendar" control. Where do I find the DTPicker control? Thanx in advance for your help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/Time Picker
also look for an entry called
Microsoft Date and Time Picker Control, version n.n -- HTH RP "Tom Ogilvy" wrote in message ... Assuming in the VBE editing a userform: did you do Additional Controls in Tools=Additional controls (A userform should have the focus) In the workbook, click the other controls button at the bottom of the control toolbox toolbar (the crossed tools icon). -- Regards, Tom Ogilvy "Obie" wrote in message ... I don't have the DTPicker control in my control toolbox. I looked in the "additional controls" and only saw the "calendar" control. Where do I find the DTPicker control? Thanx in advance for your help. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/Time Picker
Hi Ron:
Thanx for your help. I actually have VS.Net. I use Date/Time Picker in VB.Net, but I'm trying to use it in VBA. Is it possible to get the control from VB.Net? "Ron de Bruin" wrote: Read Chip Pearson's note's The DTPicker (Date Time Picker) control is distributed with the Visual Studio applications (Visual Basic (not VBA), Visual C++, etc), not with Office/VBA. You will have to purchase a VS or VSNET application. -- Regards Ron de Bruin http://www.rondebruin.nl "Obie" wrote in message ... I don't have the DTPicker control in my control toolbox. I looked in the "additional controls" and only saw the "calendar" control. Where do I find the DTPicker control? Thanx in advance for your help. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/Time Picker
Hi Obie
In the VBA editor Right click on the Toolbox with controls (View Toolbox) Choose Additional controls Is it on this list? -- Regards Ron de Bruin http://www.rondebruin.nl "Obie" wrote in message ... Hi Ron: Thanx for your help. I actually have VS.Net. I use Date/Time Picker in VB.Net, but I'm trying to use it in VBA. Is it possible to get the control from VB.Net? "Ron de Bruin" wrote: Read Chip Pearson's note's The DTPicker (Date Time Picker) control is distributed with the Visual Studio applications (Visual Basic (not VBA), Visual C++, etc), not with Office/VBA. You will have to purchase a VS or VSNET application. -- Regards Ron de Bruin http://www.rondebruin.nl "Obie" wrote in message ... I don't have the DTPicker control in my control toolbox. I looked in the "additional controls" and only saw the "calendar" control. Where do I find the DTPicker control? Thanx in advance for your help. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/Time Picker
Hi Tom:
Thanx for your help. I looked at "additional controls" in both places (ie Tools=Additional Controls, and by right-clicking at the bottom of the toolbox. They go to the same dialog box, and there's no DTPicker there. Just the "calendar" which is a different thing really. "Tom Ogilvy" wrote: Assuming in the VBE editing a userform: did you do Additional Controls in Tools=Additional controls (A userform should have the focus) In the workbook, click the other controls button at the bottom of the control toolbox toolbar (the crossed tools icon). -- Regards, Tom Ogilvy "Obie" wrote in message ... I don't have the DTPicker control in my control toolbox. I looked in the "additional controls" and only saw the "calendar" control. Where do I find the DTPicker control? Thanx in advance for your help. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/Time Picker
Hi Bob:
Thanx for your help. I have looked under this title and found the control under ASP.Net. I guess I can download it from there. First, I'll install my VB.Net and see if it gets picked up from there. "Bob Phillips" wrote: also look for an entry called Microsoft Date and Time Picker Control, version n.n -- HTH RP "Tom Ogilvy" wrote in message ... Assuming in the VBE editing a userform: did you do Additional Controls in Tools=Additional controls (A userform should have the focus) In the workbook, click the other controls button at the bottom of the control toolbox toolbar (the crossed tools icon). -- Regards, Tom Ogilvy "Obie" wrote in message ... I don't have the DTPicker control in my control toolbox. I looked in the "additional controls" and only saw the "calendar" control. Where do I find the DTPicker control? Thanx in advance for your help. |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/Time Picker
That would mean it isn't installed on your system. I believe Ron advised
that it is distributed with Visual Studio or also with one of the languages found in Visual Studio. I am not familiar with the licensing restrictions on it, so I can't advise. My advice assumed you had a valid copy of the control installed. -- Regards, Tom Ogilvy "Obie" wrote in message ... Hi Tom: Thanx for your help. I looked at "additional controls" in both places (ie Tools=Additional Controls, and by right-clicking at the bottom of the toolbox. They go to the same dialog box, and there's no DTPicker there. Just the "calendar" which is a different thing really. "Tom Ogilvy" wrote: Assuming in the VBE editing a userform: did you do Additional Controls in Tools=Additional controls (A userform should have the focus) In the workbook, click the other controls button at the bottom of the control toolbox toolbar (the crossed tools icon). -- Regards, Tom Ogilvy "Obie" wrote in message ... I don't have the DTPicker control in my control toolbox. I looked in the "additional controls" and only saw the "calendar" control. Where do I find the DTPicker control? Thanx in advance for your help. |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/Time Picker
Hi Bob:
Yes, the name is "Microsoft Date and Time Picker, Version 6.0". I think it showed up on the "additional control" list only after I installed VS.Net. Infact, I see many other good controls there. Thanx a lot for the useful tip. "Bob Phillips" wrote: also look for an entry called Microsoft Date and Time Picker Control, version n.n -- HTH RP "Tom Ogilvy" wrote in message ... Assuming in the VBE editing a userform: did you do Additional Controls in Tools=Additional controls (A userform should have the focus) In the workbook, click the other controls button at the bottom of the control toolbox toolbar (the crossed tools icon). -- Regards, Tom Ogilvy "Obie" wrote in message ... I don't have the DTPicker control in my control toolbox. I looked in the "additional controls" and only saw the "calendar" control. Where do I find the DTPicker control? Thanx in advance for your help. |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date/Time Picker
Hi Obie,
Yeah it's version 6.0, I guess it's also from my VS.Net. Glad you are all sorted. Bob "Obie" wrote in message ... Hi Bob: Yes, the name is "Microsoft Date and Time Picker, Version 6.0". I think it showed up on the "additional control" list only after I installed VS.Net. Infact, I see many other good controls there. Thanx a lot for the useful tip. "Bob Phillips" wrote: also look for an entry called Microsoft Date and Time Picker Control, version n.n -- HTH RP "Tom Ogilvy" wrote in message ... Assuming in the VBE editing a userform: did you do Additional Controls in Tools=Additional controls (A userform should have the focus) In the workbook, click the other controls button at the bottom of the control toolbox toolbar (the crossed tools icon). -- Regards, Tom Ogilvy "Obie" wrote in message ... I don't have the DTPicker control in my control toolbox. I looked in the "additional controls" and only saw the "calendar" control. Where do I find the DTPicker control? Thanx in advance for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pop up Date time picker | Excel Discussion (Misc queries) | |||
Date Time Picker | Excel Discussion (Misc queries) | |||
Date and Time Picker | Excel Discussion (Misc queries) | |||
date time picker | Excel Programming | |||
Set Value for Date/Time Picker | Excel Programming |