loading DTPicker control

Sachin2k6

Active Member
Joined
Mar 3, 2012
Messages
362
hi all,

In my program i used a DTPicker control . On my system it is available and works fine but when i run my program on another system ,got an error because that control was not available on that machine. My question is that how to load DTPicker control on a system if it is not available on it????
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Tinbendr

Well-known Member
Joined
Jul 21, 2010
Messages
997
It's well know that datepickers do not play well across version of Office, and sometime OS's. There are several USERFORM type calendar controls that eliminate this problem. Here's one.
 

Sachin2k6

Active Member
Joined
Mar 3, 2012
Messages
362
My question was that how to load same control i used in my code, on another system if it is not available on that machine??? Is it possible or not???
 

Tinbendr

Well-known Member
Joined
Jul 21, 2010
Messages
997
I thought I answered your question quite well given the lack of details in your original post.

The answer is probably not. You'll have to replace the built-in date picker with one made from a standard userform which is stable across version. Those tend to work across Office versions and OS's.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,224
Messages
5,594,914
Members
413,952
Latest member
JGer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top