Thanks for the suggestion about the Data Form. We don’t have plans to implement this in the near future, so we’re marking it “Not at this time”.
We recommend using Tables to make data entry easy. To create a table, just press CMD+T. With a table, you can press TAB to move across the fields and then it will automatically go to the beginning of the next line if you’re at the last field. If you’re on the last record in the table, it will add a new record to the end of the list.
Please comment to let us know what other reasons you’re using the Data Form that make it easier/better than using a Table.
An error occurred while saving the commentAnonymous commented
You're asking why we can't use TABLES instead of FORMS. My question is why can't the FORMS function come to MAC? It is very easy to go to a button to create form on the fly with WINDOWS. Now, we have to look for VBA scripts to recreate this same function in a MAC OS environment.
I agree that if it's available for WINDOWS, then it should be available for MAC. Your suggestion to make a table within the sheet will not work to replace this feature. I can TAB across the row currently and I don't need to create a table to do that. The FORM feature in EXCEL provides a GUI that removes all other distractions and makes it easy for entering data. It lets you TAB down through the fields (instead of TAB across like you can now) and select ENTER to proceed to the next row. You have buttons already created to let you move through the records and now, we have none of that for MAC.
This is not a request for something that can't be done in EXCEL. This is a feature that clearly is used by many people in WINDOWS and it should be reinstated.
In the meantime, since this is not a demand but a simple request, would you be so kind as to post the VBA script for recreating the form that natively appears in EXCEL for WINDOWS? That way, we can create the form from scratch using your code and we can wait for you to implement the feature for MAC. We understand that this is a small request but us mere mortals only have the little things in life to help our day to day lives easier. Please please please bring this to MAC.