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
mikeretyred's avatar
mikeretyred
Copper Contributor
Mar 20, 2019

Thanks MaxDC for the suggestion.  Since my post I've tried harder !

As a novice to extended use of Excel and VBA and who glazed over at Pivot Tables it was necessary to explore further and fortunately I've found a few useful formulae (SUMIFS etc) that combined with VBA have enabled a workaround for the Data Entry Form.  I'm attempting to create an Excel alternative to MS Money, for which all the claimed alternatives I've tried over the years aren't.

And I'm slowly getting there - a fascinating and absorbing project as I approach 80 this year - and yes, I know I should get out more.

I'd welcome advice from anyone who has developed an Excel alternative to MS Money.

scg216's avatar
scg216
Copper Contributor
Jul 18, 2019

I have never used MS Money.  However, my Office 365 does not have the Data Form and VBA features I need, so I downloaded Office 2011, then updated it with the 14.7.7 update.  All the Data Form and VBA features exist in this version.   From what i I see the description of MS Money, you can reproduce what you want using Office 2011.  Good luck!mikeretyred 

Resources