Hi everyone,
It will be obvious I am a nooby in this great group of thinkers, but here goes anyway;

Really there are two questions that each answer could be the solution to the problem; I have a userform similar to a message box that I am trying to add a label that will have a changing caption based upon a changing value in a particular cell on the active worksheet. I am pretty sure I can figure it out if I can just get the caption to show up on the userform based upon the code rather than the properties caption method. So that's question 1 - how to code the label to make the caption appear on the userform.

Question 2 - ha ha. I laugh because I have been working on this for so long and it seems that the answer SHOULD be so darn simple that my question was going to be very strongly worded indeed. (I strongly word the question to myself all the time!!) So, gentle now - I can use a textbox to do the same thing as question # 1 , except I cannot figure out how to get the text to show up without the user beginning to type into the textbox. So..........How the heck, (easy now), do I activate a textbox without user intervention? In this fashion I can use a textbox as a label if I need to. I can use this answer in so many places!

My remaining two hairs will remain if only someone can please just answer the two questions above. I will be forever grateful!

In your debt,
JasonRay