Forum Discussion
null null
Nov 14, 2018Copper Contributor
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...
JKPieterse
Nov 14, 2018Silver Contributor
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.
null null
Nov 14, 2018Copper Contributor
So basically no solution? Thanks.
- scg216Jul 18, 2019Copper Contributor
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.
- JKPieterseNov 14, 2018Silver ContributorWell, 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.