View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones[_2_] Norman Jones[_2_] is offline
external usenet poster
 
Posts: 421
Default referring to a textbox on a different userform.

Hi Aintlifegrand79,

In the module of the ufZipCodeMarket
Userform, try pasting the following code:

'=============
Private Sub CommandButton2_Click()
Dim sStr As String

sStr = Me.TextBox1.Value

With ufRepInfo
.Show
.TextBox1.Value = sStr
End With

End Sub
'<<=============



---
Regards.
Norman


"aintlifegrand79" wrote in
message ...
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