excel 2010 vba
What I have:
I have a userform that contains a cmdButton1
What I need:
I need to copy values down ROWS ON A a worksheet determined by a numeric value in the textbox1
Along with text from textbox2.
If i know my cell to start the posting say "K4"
So in Textbox1 - I type in "10"
I want to copy the following values for 10 rows from. L4 (because L4 is adjacent column to K4)
Textbox2 - I type in "DO NOT CROSS THIS ITEM"
I press command button
L4 TO L14 WILL CONTAIN "DO NOT CROSS THIS ITEM"