jewkes6000
Board Regular
- Joined
- Mar 25, 2020
- Messages
- 60
- Office Version
- 365
- Platform
- Windows
I have created a massive workbook with tons of macros. Many of the these macros use UserForms with Listboxes. The workbook seems to work great with other Windows users; however, it has several issues with people who use a Mac. For example, some of the macros will bring up a ListBox for them to choose an item from. For Windows users, it works fine; however, for Mac users, the ListBox is blank not allowing the user to select anything.
Another issue which arose but I was able to fix was I was using a custom mouse icon so that when you hover over a button in a UserForm, the mouse pointer changed to a different icon. Apparently, this was causing major issues for Mac users and they couldn't even run those macros, and in some cases, couldn't even really open the workbook. By removing the custom icon, they were then able to use the workbook; however, they still have the problem above not being able to select from ListBoxes.
I have a couple questions here:
Another issue which arose but I was able to fix was I was using a custom mouse icon so that when you hover over a button in a UserForm, the mouse pointer changed to a different icon. Apparently, this was causing major issues for Mac users and they couldn't even run those macros, and in some cases, couldn't even really open the workbook. By removing the custom icon, they were then able to use the workbook; however, they still have the problem above not being able to select from ListBoxes.
I have a couple questions here:
- Is there a solution to make the ListBoxes work properly?
- Is it worth it to address issues with Mac & Windows compatibility? Or is this an endless road I'll be going down with problems arising all the time?