Is there a way to use a variable in a userform text box? I have a Userform
I'm creating that has a text box. I want the text to say: "The following X
files will be consolidated for the month of Y." I will have variables X and
Y such that X will be equal to some integer and Y will be some string that
will be the name of a particular month. So say I have X = 4 and Y = March
then my text box should read: "The following 4 files will be consolidated for
the month of March."

How do I do this?