UserFrom : Select Range And Show In Text Box : Solved by : Bernie Deitrick

hello evryone

I M Using A UserForm To Select Range Select

In UserForm i have three Textboxes

1st Textbox's value is set = N:N

2nd Textbox's value is set = O:O

3rd Textbox's value is set = P:P

I Need If I set 1st TextBox's Value = N3:N15 then

Should be auto value of 2ND textbox = O3:815
AND
Should be auto value of 3rd texbox = P3:P15

thanx

In the change event of TextBox1:

Private Sub TextBox1_Change()
On Error Resume Next
Me.TextBox2.Text = Range(Me.TextBox1.Text).Offset(0, 1).Address(False, False)
Me.TextBox3.Text = Range(Me.TextBox1.Text).Offset(0, 2).Address(False, False)
End Sub

What do you want? Maybe??

Please Login or Register  to view this content.

Left off a paren:

Please Login or Register  to view this content.