View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Ken is offline
external usenet poster
 
Posts: 207
Default referring to a textbox on a different userform.

Maybe this will help:

If you have two userforms, userform1 and userform2, they both have a
textbox1 and one has a commandbutton1. If you have them both shown,
maybe using code like:

Sub test()
UserForm1.Show modal
UserForm2.Show modal
End Sub

If the code associated with the command button on the first userform
is:

Private Sub CommandButton1_Click()
UserForm2.TextBox1.Text = UserForm1.TextBox1.Text
End Sub

and you put some text in textbox 1 on userform1 and click the button,
that text will show up in the textbox on userform2.

Good luck.

Ken
Norfolk, Va

On May 22, 2:13*pm, aintlifegrand79
wrote:
I am using two userforms ("ufZipCodeMarket" and "ufRepInfo") and want to
populate the textbox ("tbZipCode2") on userform("ufRepInfo") by entering a
value into the textbox ("tbZipCode") on userform ("ufZipCodeMarket") and
pressing a command button ("cbFind") on that userform. *Thank you for you help