My first post, so hello and thanks in advance.
I'm getting back into excel after a long time away, and am stumped.
I have a sheet which I plan to use for stock control, I have done the data entry and search, but on one of the forms I need to load and edit data from a row number which is specified within a textbox on a userform.
I don't know how to reference that row within VBA, the column doesn't need to be dynamic - just the row.
FYI, the textbox is called "txtrow" and the userform "frmStock" then I need to load sheet5, column A and the row number from txtrow.
Any help would be greatly appreciated.