Posts by dexta211

    Re: Add data to sheet from userform with row number specified in textbox.


    I have adjusted the = to the value of textbox1 from the same userform.


    Sorry, due to the data on the sheet I am unable to share it.


    I have realised that I was initially refering the the textbox incorrectly, having now corrected that the error is "Subscript out of range".


    EDIT!


    I have now solved it, it wasn't your code - It was my sheet reference!


    Thanks for your help p45, greatly appreciated!

    Hi all,


    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.