Date/Time Picker

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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).
 
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.
 
also look for an entry called

Microsoft Date and Time Picker Control, version n.n
 
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?
 
Hi Obie

In the VBA editor
Right click on the Toolbox with controls (View Toolbox)
Choose Additional controls

Is it on this list?
 
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.
 
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.
 
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.
 
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.
 
Hi Obie,

Yeah it's version 6.0, I guess it's also from my VS.Net.

Glad you are all sorted.

Bob
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DTPicker controls missing from userform 4
Problems with MS-DateTime-Picker 6.0 2
Macro to modify property of an object 6
Date & Time Picker Properties Question 19
Getting right date value 1
Custom Date Picker Control 3
Set DTPickers Data to Todays Date by Default 1
Control to pick time? 3

Back
Top