MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How do I pass text from a label in a user form by clicking an option to a text box in another user f


Posted by Kurt on July 19, 2000 11:57 AM

Help!!

I need to pass text from a user form where there are four to six options to another user form and display that selection in a text box in the other user form.

Thanks again,

Kurt


Posted by Ryan on July 19, 0100 12:27 PM

Kurt,

You can do this:

UserForm2.TextBox1.Value = UserForm1.TextBox1.Value

This is generic and can be fitted for any need


Ryan

Posted by Kurt on July 19, 0100 12:42 PM

Second question

Hello Ryan,

In place of TextBox1 can I sustitue OptionButton1 so that when the user clicks on it the label is passed to the Text box in UserForm2?

Thanks for you ever so quick responses.

Kurt

Posted by Ryan on July 19, 0100 1:01 PM

Re: Second question

Kurt,

Here you go:

UserForm1.OptionButton1.Caption = Userform2.TextBox1.Value


Ryan