Macro Speed (Userform vs Msgbox)

[DHogg]

I have a macro with a msgbox that pops up when a button is clicked. There are about 10 of these which can contain a lot of text. This is making the workbook slow to open, and process some of the other macros (which were fine before I added the msgbox buttons)

My question: Would it be any faster if i created userforms with the text in them instead of using a msgbox?

 

[rjwebgraphix]

I would think so if.... You could combine multiple msgbox prompts into a single UserForm and get any needed user input from one UserForm instead of 10. They could just fill out the one userform and the macro has all the information it needs.

 

[DHogg]

Well, there is no actual input into the userform. It is just a pop up.

However, they do need to be separate as they relate to different information. I have a button next to the criteria so the user can reference when required