Problems Pasting Values to User Forms

Posted by Kurt on July 25, 2000 11:47 AM

Hello Ryan,

I can get this to work in one instance, but I keep having problems trying to do this in several user forms. Do you have any ideas or suggestions. Here's part of my subroutine:

Private Sub TextBox1_Change()
If QUESTIONS.TextBox7.Text = "SHAMPOO/CONDITIONER" Then
Sheets("SHAMPOO_CONDITIONER").Select
Range("E7").Value = TextBox1.Text
'Worksheets("SHAMPOO_CONDITIONER").Range("E7") = ONE_YEAR_AGO.TextBox1.Value
'ONE_YEAR_AGO.TextBox1.Value = Worksheets("SHAMPOO_CONDITIONER").Range("E7").Value
End If

End Sub

QUESTIONS Is a User Form and SHAMPOO_CONDITIONER is another user form where I am having the promblems retrieving the values.

Help!!!!

Thanks again,

Kurt

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

Kurt,

Why do you have soooo many userforms. It seems like the ideal thing for you is to have one user form and set up a multipage on it, then hide the tabs when done. This will give the appearance of multiple userforms but the ease of working w/ just one. I don't see any problems with this code, so I can't offer up any help.

Ryan

Posted by Kurt on July 25, 0100 12:47 PM

Ryan,

Because I have soooo many sheets!! :-) I am trying to make an interface so that the user has to click on choices on the user form to go any further.

Thanks for all your help

Kurt