I a beginner with Excel.

I've created UserForm1 with 3 labels and 3 textboxes (email, first name, last name), captured the entries and validated them. I then wanted to use those values as captions in UserForm 2. But I couldn't make UserForm2 work. So I created a simple test form to try it, and couldn't make that work either. I've tried both a hard coded string and a simple string variable. Neither worked. I placed this code in the VBA area attached to the UserForm.

I would sincerely appreciate any suggestions that you can offer.



Very respectfully,
Larry

Hi and welcome
in the future please wrap code with code tags ( click -Go advanced - select code - click the #button)
I did it for you this time
Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Try

I know that, in the fields where I have significant experience, one difficulty in talking to beginners is that what's blindingly obvious to a person with *any* experience at all is completely opaque to a beginner.

I tried the code that you suggested and could not make it work. After practicing my black language skills and bruising my forehead, I gave up and went to bed. But I had a thought when I woke this morning: you'd use "show" . . . I'd used that command in a module rather than the userform's VBE. I created a module, inserted the code that you suggested into the module, and it worked first try.

Thank you!

And I annotated this in my "Excel VBA Programming for Dummies" to increase the chance that I'll remember it next time. Now I need to try understanding where VBA expects me to put things.

VERY respectfully,
Larry