Hi,
I'm in big trouble with a VBA project.
Situation: xlsm file, incuding two userforms. UF1 includes a multipage (8 pages) with about 80 option buttons, 90 labels, 60 text boxes, 20 check boxes and 10 command buttons, using two worksheets (sheet #1 86 columns, sheet #2 just a few constant configuration data). UF2 has about 150 labels and one command button
Works absolutely flawlessly with 32bit Excel versions (2016, 2019). No activeX controls.
With 64bit Excel (2016 as well as 2019)
- I can open and run everything perfectly
- after having it saved, I can open it again and use it
- after having it saved 2nd time, I can open it, but Excel quits immediately when in UserForm_Initialize() any setting of a control's property is being performed, not depending on wether the setting is performed within the initializing routine or via an extra sub. (starting the userform manually shows an error window, claiming the well known error 400) When - with this corrupted file and still within 64bit Excel - I reopen it skipping makro execution, edit anything at any line (for instance adding and instantly removing a colon), save and quit, I again can open and use the file two times.
Opening and using even this "64bit maltreated" file with 32 bit Excel never is a problem. But, unfortunately, the final user has 64bit Excel only. It's quite urgent, they need it for a (medical) scientific project -- and in the current situation, they even can't check the "alpha" and "beta" versions, so further development is pretty impossible.
It's a non profit project, I don't get a cent for it, just a smile.
Any help at the horizon? Would be great.
Bookmarks