Textbox1.Text = ws.Cells(r,"A").Text?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Oreg " wrote in message
...
Hello,

I've created a user form with various text boxes and comboboxes which
enters info into specific columns on a worksheet named "METRO". The
code I used to enter the data searches for the last cell, (in METRO),
with data in a specific column and offsets it by one so the new info,
(plugged into the form), is entered in the next "empty" row. I've
listed a portion of the code I used below.
r = ws.Cells(Rows.Count, 5).End(xlUp).Offset(1, 0).Row

Column A of worksheet METRO is labeled as 'ticket number" which is
populated by a formula that is linked to another sheet.


On the user form I've created is a textbox I would like to have display
the ticket number that the data entered into the form will populate.
I hope I didn't get too long winded or confusing. Any Ideas???


---
Message posted from http://www.ExcelForum.com/