[Help Please]Parsing parameters to event

[ardha]

Please help me...

I'm working in 2 form:

UserForm1 contains button1, when we click button1 UserForm2 will be load and UserForm1 will be hide.

UserForm2 contain RefEdit to select a range

And if I Click the button "Ok" the UserForm2 will hide and UserForm1 will showed.

I want the range value that have selected in UserForm2 is send to textbox in UserForm1.

I cannot do that

Please helpme Guy's...............



Thank you

[mikerickson]

Putting this in the userform2's command button routine should do it.
[VBA]Private Sub cmbRangeTo1_Click()
On Error Resume Next
With Me.RefEdit1
UserForm1.TextBox1.Text = CStr(Range(.Value).Range("a1").Value)
End With
Me.Hide
UserForm1.Show
On Error Goto 0
End Sub[/VBA]

[ardha]

Thank you Mikericson... it's works.......