Userform: Corrupted appearance on a different computer

theguynamedjake

New Member
Joined
Sep 1, 2018
Messages
2
Hey guys,

I'm new to this sub. I tried to look for related posts first but to no avail.

I created a userform with tons of (working) controls, uploaded to cloud and downloaded it on other computers. The file's main usage will be on the userform. The issue is, on most computers, the userform only shows a blank multipage showing default page names. Nothing more.

What I've done so far:
1. Debugged, made sure there are no syntax errors on the code
2. Made sure the other computers have FM20.dll registered
3. Vba references were set to the 5 basic ones. Ms forms 2.0, etc
4. On the other computer, removed the form and imported .frm (with .frx on the same folder) which was exported from the original computer
5. Compiled the .xlsm and .xlsb versions to .exe using xcell to see if the new format will fix the issue

Additional info that might help
1. I'm using sa 32 bit MS Excel 2016
2. I'm on a 64-bit Windows 10 computer
3. Tried a code stolen from a forum that removes the title bar for forms, and another one that activates mouse scroll,but are both incompatible and caused my project to crash
I removed the modules afterwards

Feel free to probe from me. This project is supposed to be used by everyone in my company. Any help will be much appreciated. Thanks guys.
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Hello,
One problem could be if the use changes the default window font or icon size to 125% the userform will distort.
 
Upvote 0
Longshot, but do you have code in the Mulitpage page change event that then changes the page?
 
Upvote 0

Forum statistics

Threads
1,223,893
Messages
6,175,240
Members
452,621
Latest member
Laura_PinksBTHFT

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
Back
Top