DTPicker not working after sending

[mdeheus90]

Hi all,

I have a problem and I have trouble finding an answer.

For my company I have created a file with a UserForm to fill in Data via Text and Combo boxes. Next to that i have used the DTPicker. After sending the file to my boss to check it out it failed as Fucntions are not available on his machine.

I know it can be fixed by adding the DTPicker to his computer, however. This file is to be used by external agents doing activities for the company. I cannot add the DTPicker on all there computers.

Is there a way to embed the DTPicker so it will still work after sending it out.

Thanks for the help!!

 

[Andrew Poulsom]

Anyone using your workbook must have MSCOMCT2.OCX that contains it. There is no way to embed it in your workbook.

 

[mdeheus90]

That unfortunate!

Any suggestions on a workaround?

 

[Andrew Poulsom]

I just use ComboBoxes for day, month and year.