error opening forms on other machines

[orsm6]

Hi all - I built a sheet that contains userforms. the forms has button that loads the monthview control (as a date picker). when other people try to click on the date picker button (command button that calls month view form) they get an error message: could not load some objects because they are not available on this machine.

is there an easy fix that can resolve this for any user (hopefully without having to make changes to resources etc)......

otherwise is there a better date picker that could be used that would work regardless of who opens it?

 

[Zot]

As far as I know the build-in date picker in 32-bit Excel is not in the 64-bit Excel. It cannot work on the 64-bit Excel.

 

[Zot]

Have a look at these

Home | Ron de Bruin Excel Automation

Welcome to https://www.rondebruin.nl

www.rondebruin.nl

Excel date picker add-in — Rad Sheets

A modern date picker for excel

samradapps.com

 

[orsm6]

Have a look at these

Home | Ron de Bruin Excel Automation

Welcome to https://www.rondebruin.nl

www.rondebruin.nl

Excel date picker add-in — Rad Sheets

A modern date picker for excel

samradapps.com

I have looked at the first one - it mentions add-ins required. If i made my date picker like the Ron De Bruin one, will the next user be able to run it or are they going to have to install the Add-in also?

 

[Zot]

I think both are xlam. Ron De Bruin showed how to call xlam through VBA. You can see the code setting xlam as TestWkbk

Well, xla is just a blank workbook with macro saved as xla. You can make your own date picker with guide from here perhaps

Fully Customizable VBA Date Picker

I recently created a customizable, VBA-based date picker, and thought it might be of use to someone else. I know there are already a lot of custom date pickers out there to overcome the difficulties of using Microsoft's MonthView control. But I wanted one that could be customized to match the...

chandoo.org