Forum Discussion
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...
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.
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.
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
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.- Does macro work?
Sub OpenDataForm()
Application.CommandBars("Worksheet Menu bar").FindControl(id:=860,recursive:=true).Execute
End SubI tried this on my mac excel but no joy
