DTPicker Object Missing?

E

Edward

There is a file that hasn't been used for some time, but suddenly need
to work on it again, however, the vba (form) can be executed and viewd
in my computer only (but not in my colleagues computer). Forgot how to
do this.

Whenever in other computer to open this file, There are a dialog box
"Microsoft Forms" apepars and say "Unable to load the object, because
it's not exist".

What I did in the file is used two DTPicker (Date Time Picker) Object
to let user to input a date in the VBA forms. but when i opened in
other computer, even that two input boxes are disappeared when i open
that form again. (same message appears.)

I think I have missed importing an actiex object something but forget
what i have missed, can anybody advise me steps to recover this?

Thanks.
 
L

Leith Ross

Hello Edward ,

The original control is an older version. The newer machines wil
require a current object reference.

1. Bring up the VB editor from Excel using *ALT + F11*
2. Select the UserForm the control(s) will be placed on
3. Display the Controls dialog using *ALT + V* then press *X*
4. Display the Additional Controls dialog using *ALT + T* then pres
*A*
5. Scroll through the list until you find *Microsoft Date and Tim
Picker Control*
6. Select the *highest version number* by left clicking the box on th
left
7. Press *Enter* to exit
8. Save the control in the project by using *CTRL + S*

You should make a copy of this file from one of the newer systems an
keep on file. You can then distribute these without redoing thi
procedure each time.

Happy Holidays,
Leith Ros
 
D

Dave Peterson

I think that the MS version of the calendar control comes with Access. If the
other users don't have Access, maybe you could use the calendar control that Ron
de Bruin suggests at:
 
Top