I'm not an expert in vba in excel, however I would like some help. I
have a worksheet with a named range called "Data". And, also on the
worksheet I have a command button that initiates a userform. On that
userform I have TextBox1.Value and TextBox2.Value...after the OK button
is clicked within the userform, it inserts the data from the userform in
the last row of that named range. I have part of the code to that adds
the data to the worksheet, but the named range area stays the same. How
do I get this to work. This is what I have so far:

Sheets("Sheet1").Range("A65536").End(xlUp)(2, 1).Value = TextBox1.Value

Sheets("Sheet1").Range("A65536").End(xlUp)(1, 2).Value = TextBox2.Value

Sheets("Sheet1").Range("A65536").End(xlUp)(1, 3).Value = TextBox3.Value


Thanks in advance...


--
sulrich
------------------------------------------------------------------------
sulrich's Profile: http://www.excelforum.com/member.php...o&userid=19975
View this thread: http://www.excelforum.com/showthread...hreadid=345553