1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'HTML, Graphics & Programming' started by doodah, Nov 13, 2017.

  1. doodah

    Capodecina

    Joined: Oct 18, 2002

    Posts: 15,361

    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:

    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.
     
  2. AHarvey

    Sgarrista

    Joined: Mar 6, 2008

    Posts: 8,078

    Location: Stoke area

    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.
     
  3. doodah

    Capodecina

    Joined: Oct 18, 2002

    Posts: 15,361

    Location: London

    Not a bad idea but considering the nature of the data, I am not sure. Need to look into/ask. Thanks.
     
  4. nightmare99

    Mobster

    Joined: Oct 19, 2006

    Posts: 3,531

    Or MS Forms if you have an Office 365 business/enterprise plan.
     
  5. AHarvey

    Sgarrista

    Joined: Mar 6, 2008

    Posts: 8,078

    Location: Stoke area

    Does that work ok on Apple products? I've not used it myself and I'm not an Apple fan either so I've no experience with it.
     
  6. nightmare99

    Mobster

    Joined: Oct 19, 2006

    Posts: 3,531

    Its a web-based form and should be mobile responsive yes.
     


Share This Page