Share via

FORMS: How do I create a registration form in Excel and be able to use it on Apple iPads for student sign in?

K Williams 0 Reputation points
2024-05-14T12:34:44.56+00:00

Hi all - I need some help, pretty please! I have a sign in form I have created using VBA in Excel and it works great (my first one). The form contains boxes for Name, Cell, Email, a checkboxes question, a dropdown question and an options question - and flows to a table tab in the file when they Submit. Now I just found out that they will be using the form on Apple iPads for the students to sign in. The hard part here is they do NOT have Excel on the iPads and can't afford to do so.

Best Case: Get the Excel sign in form loaded on the iPads in Sheets (she said Sheets but I think that's Numbers) but still have the data that is submitted flow to the spreadsheet table (ideally not on the iPads but ok if a must). And, I'm guessing I will have to share over a cloud that can transfer all the functions (no idea which that is but needs to be free, file sizes are all small). So, they sign in on 3-4 iPads and each time a Submit happens it flows to Excel table on my computer. I have zero idea if that is all possible - which is why I'm asking the geniuses here!

Next Best: Is any option between the above and the below. LOL!

Worst Case: I have to create the form and table all over again in Numbers. I spent so much time on the VBA coding this would be such a shame.

Help me please! TIA! Questions about it, just ask.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,553 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 22,636 Reputation points Microsoft Vendor
    2024-05-15T01:48:54.6566667+00:00

    Hi,

    As far as I know macros (VBA code) are only supported in the desktop versions of Excel for Windows and MacOS. They don't work on iPhone, iPad and Android phones, nor in the online (browser) version of Excel.

    In my opinion, you can try to check if the Microsoft Forms will help you to create survey for you:

    https://forms.microsoft.com

    You can refer to this article to check if this product will help you:

    https://www.microsoft.com/en-us/microsoft-365/blog/2020/10/22/survey-or-quiz-your-friends-and-family-with-microsoft-forms-now-available-for-personal-use/

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.