PDA

View Full Version : [Help Please]Parsing parameters to event



ardha
06-19-2008, 04:58 PM
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
06-19-2008, 06:27 PM
Putting this in the userform2's command button routine should do it.
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

ardha
06-20-2008, 01:26 AM
:clap: Thank you Mikericson... it's works.......