Forum Discussion
2019 Excel on Mac no data entry form
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.
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
scg216 Hi, thanks for your interest.
In fact I moved on from original obstacle posed by lack of data entry form
Using vba to transfer data to a ‘flat’ data table from worksheets that simulate entry forms for such entry types as DDR’s, regular transactions and periodic / budgeted transactions I can / will be able to create output reports and charts that come somewhere near to MS Money.
(Incidentally the driver to convert from splendid old MS Money came first from it’s slowness on Parallels on my mac mini; BUT replacing the HDD with a whisper quick SSD cured that BUT M’Soft bless their cotton socks the decided to cease support for Win7 so the project must be done by Jan’20)
The project is taking a while but I will get there and I will learn more about vba from helpful sites like this.
Regards Mike