I have been working on an experimental clinical data analysis tool in Excel using VBA userforms for the data entry UI. Because there are more than 100 unique userforms (and growing) it has become necessary to build the UI screens programmatically at runtime to avoid the VBA environment in Excel freezing when more than +/- 40 userforms are stored. I have been helped greatly at Stack Overflow to help programmatically build the userforms.
Recently I discovered Power Apps forms. It looks better than VBA userforms, has built in SQL functionality, but more importantly the forms will exist outside of Excel's finicky VBA environment. There is almost no online information out there about the integration of Power Apps in Excel. I need to remain using Excel spreadsheet to crunch the data because it is the comfortable and familiar sandbox for me to play in.
So my question, is integration of MS Power App Forms into Excel a viable alternative to replace native VBA userform functionality in Excel? I want to know ahead of time to avoid entering a time consuming rabbit hole just to discover it is not actually viable.
It looks like the best answer to my question is a non-answer. After several weeks no one has provided input as to how the integration of MS Power Apps forms into Excel can best can be achieved. It is likely not a feasible alternative to VBA userforms at this time (early 2023).