Date Picker is not working on other syste

elsuji · Jan 22nd 2020

Dear Team,

i am using date picker on my userfor3. For that i had enabled date picker on my system and it is working great.

but the problem is when i am sending this file to my superior, this date picker is not working. I am getting error message "Could not load an object because it is not available on this machine". Obviously this message will display because of all other system this option will not enable.

So kindly help me how to resolve this issue.

I am attaching my file here for your reference

**Carim** · Jan 22nd 2020

Hello,

There are several considerations and questions :

which Excel Version ? Are you using an ActiveX Control ? Which platform 32 Bit or 64 Bit ?

For 64 bit Excel, you can use either Sam Radakovitz's or Ron De Bruin's Date Picker Add-in :

http://samradapps.com/datepicker/

http://www.rondebruin.nl/win/addins/datepicker.htm

Hope this will help

elsuji · Jan 22nd 2020

Dear Carim,

How to add this on user form listbox.

And weather this works only on my stem or it will work for any system. Because i sent this file to another person. But the month view which i am using currently on my userform is not working on his system.

**Carim** · Jan 22nd 2020

Re,

Why are you not answering the main questions ...!!!

which Excel Version ?

Are you using an ActiveX Control ?

Which platform 32 Bit or 64 Bit ?

elsuji · Jan 22nd 2020

I am using excel 2013 and 64bit and not using activex control

**Carim** · Jan 22nd 2020

Quote from elsuji

I am using excel 2013 and 64bit and not using activex control

Thanks ...

And your Supervisor ...?

elsuji · Jan 22nd 2020

http://samradapps.com/datepicker/

**Carim** · Jan 22nd 2020

Quote from elsuji

http://samradapps.com/datepicker/

The Best is to use the same ...

It is the Best solution ...

elsuji · Jan 22nd 2020

how to add this in my userform

**Carim** · Jan 22nd 2020

Quote from elsuji

how to add this in my userform

If my memory serves me right ... there is an installation procedure written by Sam ...

elsuji · Jan 22nd 2020

The installation procedure is for work sheet.

And after complete the work, if I send to other person weather it will work on his sysem

**Carim** · Jan 23rd 2020

Quote from elsuji

The installation procedure is for work sheet.

And after complete the work, if I send to other person weather it will work on his system

Hello,

What you seem to be asking for ... is not an add-in ... but a Calendar solution which is built-in your own VBA modules ...

If it is the case, there is a huge number of potential solutions ... such as the following:

https://trevoreyre.com/portfolio/excel-datepicker/

Hope this will help

**royUK** · Jan 23rd 2020

Take a look at my alternatives here, I've been using them for years, you can see it used in this post here.

Alternate DatePickers for Excel

elsuji · Jan 23rd 2020

Dear Roy,

I had tried Alternate DatePickers for Excel. Now the date format is working on userform3 while selecting the command button.

But i don't know how to bring the selected date to userform3 Textbox1.

Can you help me for that.

**royUK** · Jan 23rd 2020

Quote

But i don't know how to bring the selected date to userform3 Textbox1.

Sorry, what do you mean?

elsuji · Jan 23rd 2020

Dear Roy,

I want the selected date should appear on text box value

**royUK** · Jan 23rd 2020

I'll take a look

elsuji · Jan 23rd 2020

please do the needfull

**royUK** · Jan 23rd 2020

You haven't imported all the code - the global variables were missing. Also, you hadn't set g_bForm to True when calling the calendar. That needs doing so that the code will know to work with the Form

elsuji · Jan 23rd 2020

Dear Roy,

Thanks for your help. It is working properly

Date Picker is not working on other syste

Participate now!

Share

Users Viewing This Thread