hi
i would like a textbox userform (called Ref) to update with a number with in a spreadsheet
the number is in column A and it needs to show in the textbox if in column B is blank
i have tired using
Private Sub Ref_Enter()
Ref.Text = Range("b" & Rows.Count).End(xlUp).Offset(0, -1).Value
End Sub
but nothing happens
Please Help!
i would like a textbox userform (called Ref) to update with a number with in a spreadsheet
the number is in column A and it needs to show in the textbox if in column B is blank
i have tired using
Private Sub Ref_Enter()
Ref.Text = Range("b" & Rows.Count).End(xlUp).Offset(0, -1).Value
End Sub
but nothing happens
Please Help!