TextBox
 

I am making a user form in which I have two "main" TextBoxes. Below these
textboxes there are additional textboxes that the user shall be able to write
text in. However, I want these additional textboxes to have the same info as
was inserted by the user in the main textboxes as default. The idea is that
the user gives a start and an end date for a report. Then the user has the
option to choose other dates within the main interval for the sub choices for
the report. The textboxes are on the same user form so i cannot get the value
fomr the the main text boxes when i a button is clicked etc. All help very
much appreciated!!!! Please need help!!!

TextBox
 

Use the Exit event to copy it across


Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox3.Text = TextBox1.Text
End Sub


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"april27" wrote in message
...
I am making a user form in which I have two "main" TextBoxes. Below these
textboxes there are additional textboxes that the user shall be able to
write
text in. However, I want these additional textboxes to have the same info
as
was inserted by the user in the main textboxes as default. The idea is
that
the user gives a start and an end date for a report. Then the user has the
option to choose other dates within the main interval for the sub choices
for
the report. The textboxes are on the same user form so i cannot get the
value
fomr the the main text boxes when i a button is clicked etc. All help very
much appreciated!!!! Please need help!!!