Opening Excel VBA userform on Mac - Runtime Error 5

[Blobajob88]

Hi,

Could someone please help? I've created an excel VBA program with userforms and it works fine on my windows laptop but when I try to open it on a mac, I get a run-time error 5. Does anyone know why this would be and what I can do to overcome it? Please see snippets attached of the error message and the line of code it fails at.

 

[RoryA]

I can't see anything wrong with that line of code (I can replicate it on my Mac and it runs without problems).

Any chance you can post the workbook somewhere for us to have a look at?

 

[Blobajob88]

Hi RoryA,

Thanks for the reply. I'm not actually sure how you upload workbooks on this forum but can do that if you know how?

The person's mac that I tried it on is using the M1 chip which uses the Rosetta emulator, could that maybe be an issue?

I've sent it to some of my friends who have macs and some could open and some couldn't, so I'm not sure if there is a setting that needs tweaked or something?

 

[RoryA]

You'd need to upload it to a site like OneDrive or Dropbox and then post the link here.

With Mac Excel anything is possible.

I assume you are not using the Rowsource property of any controls in your form, since that will not work.

 

[Blobajob88]

CAUTION: External Email. Unless you recognise the sender and know the content is safe, do not click links or open attachments.

---

​

Hi Rory,

Could you try opening this and see if you can see the problem:

https://1drv.ms/x/s!Ag3dKjN4pDXthskFhK0cowtyBKHfCA?e=HbbvCA

Thanks

 

[RoryA]

I can open that form without errors. I do note that one of your worksheets has activex controls on it, which won't work on a Mac.