Created userform in Excel (Windows) - need to get it to run in Excel (OSX)

doodah

doodah

doodah

Caporegime
Joined
18 Oct 2002
Posts
28,459
Location
London
I have just made a simple userform in Excel 2010 on Windows for capturing information from a large number of users.

I wasn't aware of differences between userforms/VBA on Windows and OSX so the form obviously doesn't work on Mac - it asks for the macros to be enabled but then follows with:

This workbook contains content that isn't supported in this version of Excel
Click to expand...

Did some reading on the internet and have seen people mention simply editing the code to fix it but I am not sure where to start. I tried going to the back end on Mac and can see the code but everything else is missing; no tool box, no userform and no way to run the code.

Any tips? The people I will be sending this form to will be a mixture of Windows and OSX users and I just need the form to work out of the box (or at least nothing more complicated than enabling macros). Thanks.
 
Could you not create the same thing using a google form? It's compatible across all operating systems and still puts the data into a spreadsheet for you to use?

Also saves people emailing results back and you having to collate them.
 
Not a bad idea but considering the nature of the data, I am not sure. Need to look into/ask. Thanks.
 
You must log in or register to reply here.
Back
Top Bottom