How to generate a lot of questions in Microsoft Forms

SHCNakamura you won't be able to create a form with more than 100 questions because Forms has a hard limit of 100 questions. And the actual limit might be far lower if you use likert questions because each statement is treated as a question.

There is no API for creating questions although there is one for getting the responses (although I always use Power Automate to save the responses to a SharePoint list). Excel can be used for populating the answers to choice questions but not for creating the questions themselves.

I don't know VBA but there is a link https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/reference-microsoft-forms which might be useful.

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)