May 13, 2005 at 3:55 PM #1 I have a text box on a userform, when the form is opened i need the text box to display the text of column 1 of the active row,Any ideas?
May 13, 2005 at 4:10 PM #2 Re: Text box to show active row column 1Hi,How about, Code TextBox1.Text = ActiveCell.Offset(0, -ActiveCell.Column + 1)