Forum Discussion

null null's avatar
null null
Copper Contributor
Nov 14, 2018

2019 Excel on Mac no data entry form

I recently switched from PC to Mac. Then I found my Microsoft Access not available on Mac version Office. I tried to use Excel instead by creating a data entry form. Windows Excel 2016 is ok. But Mac...
excel
JKPieterse's avatar
JKPieterse
Silver Contributor
Nov 14, 2018
I'm afraid MAC Office is a bit like the ugly step-sister. Family indeed, but does not get the same amount of love as the others do. MAC Office is always a bit behind in features as Windows Office. You'll have to revert ot a VBA solution. O wait, that is no fun in Mac Office either.
  • Acadia1532's avatar
    Acadia1532
    Copper Contributor
    Nov 28, 2018
    The Mac edition of Excel has had the data entry Form... capability since at least 1990, when I started using it. Been using it since then. It is now nowheres to be found in Excel Mac 2019.
    • scg216's avatar
      scg216
      Copper Contributor
      Jul 18, 2019

      Office 2011 for Mac has all the Data Form and VBA features in it.  I found it via a 3rd party, then updated it to the 14.7.7 update.  Works fine.Acadia1532 

    • 6liuxa's avatar
      6liuxa
      Copper Contributor
      Jul 15, 2019

      Acadia1532 
      If you like me in the UK and bought Office 2019 Mac, then return it for the full price.
      On the ground of Purchase made on misleading Marketing, i.e Their manual still says you can use it though, while only from support call/pages you can find it's not.

      Luckily Google Docs getting better and better and integrates with different CRM. SO in couple years this harvest finish.

       

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Nov 28, 2018
      Does macro work?

      Sub OpenDataForm()
      Application.CommandBars("Worksheet Menu bar").FindControl(id:=860,recursive:=true).Execute
      End Sub
      • simplesi's avatar
        simplesi
        Copper Contributor
        Jan 02, 2019

        I tried this on my mac excel but no joy 

  • null null's avatar
    null null
    Copper Contributor
    Nov 14, 2018

    So basically no solution? Thanks. 

    • scg216's avatar
      scg216
      Copper Contributor
      Jul 18, 2019

      I have no options for you in regards to Office 2019.  I'm a Mac user.  I found Office 2011 from a 3rd party, installed and updated it with the 14.7.7 Update.  All of the Data Form & VBA features are available and work well in that version.

       

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Nov 14, 2018
      Well, not an easy one as far as I know. But I don't use a MAC so I might be (very) wrong on this. With Excel on-line as a part of Office 365 you can create Forms which can be edited on-line. But I have little experience with that.

Resources