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

I'm also flabbergasted and disappointed about that missing feature!null null

Looking for a solution I went to me free account at http://www.Airtable.com, imported there my excel spreadsheet as CVS format and with no delay have a data entry form for my existing data (and it's web-based!). Will export from Airtable once done.

This might be an easy solution for you, although we shouldn't have to...

 

  • 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 

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

        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

Resources