Hello,

I've created a user form with various text boxes and comboboxes whic
enters info into specific columns on a worksheet named "METRO". Th
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'v
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 i
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 displa
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