Load Userform Office 365 versus older Excel versions

[CaptDunsel]

Have macros designed using Excel 2013. They worked fine until I tried to run on 365 version of Excel. In particular, I use Load Userform, then pass information to the form before showing the userform. Apparently 365 does not allow interaction with the userform until the show command? Is there a good workaround other than using global variables prior to invoking the userform>

 

[Micron]

Use a drop box or One Drive and give anyone with the link access to it.
I don't think they like it here if I provide an email address in a pm and solve the issue, even if I post the solution afterwards. Not sure why that would be any different than you posting a link to a file. Taking the solution off line could happen that way too, but they don't seem to mind if you use a file share.

 

[CaptDunsel]

Use a drop box or One Drive and give anyone with the link access to it.
I don't think they like it here if I provide an email address in a pm and solve the issue, even if I post the solution afterwards. Not sure why that would be any different than you posting a link to a file. Taking the solution off line could happen that way too, but they don't seem to mind if you use a file share.

Try this:
Example.xlsm

 

[CaptDunsel]

Use a drop box or One Drive and give anyone with the link access to it.
I don't think they like it here if I provide an email address in a pm and solve the issue, even if I post the solution afterwards. Not sure why that would be any different than you posting a link to a file. Taking the solution off line could happen that way too, but they don't seem to mind if you use a file share.

Sorry, wrong link:
Example.xlsm

 

[CaptDunsel]

Sorry, wrong link:
Example.xlsm

If you go to Training_Exercise tab and click on cell E2, you should get error

 

[CaptDunsel]

If you go to Training_Exercise tab and click on cell E2, you should get error

Use a drop box or One Drive and give anyone with the link access to it.
I don't think they like it here if I provide an email address in a pm and solve the issue, even if I post the solution afterwards. Not sure why that would be any different than you posting a link to a file. Taking the solution off line could happen that way too, but they don't seem to mind if you use a file share.

So, I've been playing around some more, which has only served to confuse me even more than I was. I created a new file with just a regular UserForm. Worked fine. When I went to the folder and double clicked the file name, Userform bombed with same run time error 91. However, if I open the file using the recent history from the task bar - the exact same file works flawlessly. Go figure. I've never seen a problem quite like this, so I need to do more research.