Hi All,

I'm just confuse about simple things, let say i have 1 text box in userform

how do I copy value or text from textbox in a userform and paste it to a cell and auto select cell below after that?

and also the copy paste stopped if certain row was reached. example : I can copy paste & auto select below within A1:A20, but after A20, it won't be possible to copy paste to A21.

Copy value/text triggered by command button click

thanks a lot for the help