adding data to new cell

[naga_raaju]

hi

i am new to vba programing.i have small doubt

i have a button when click that button the code is like this

Private Sub CommandButton1_Click()
Sheet1.Range("b2").value="raju"

End Sub


when i click the button "raju" word will be come for b2 .again click the button it come for b3 and b4 like this.

what my question is it come for new line.

have a nice day

bye
naga

[rkjudy]

Use the forms toolbar to create the button and then use this code for the macro.

Please Login or Register  to view this content.

Also, you might want to check the rules for posting code in your thread.

[naga_raaju]

thanks for the reply

Sheet1.Range("a65536").End(xlUp)(2, 1) = "raju"

the above code work for new line but it starts from (a2,2) but i want to start it from(j11,8) how?

bye
naga

[shg]

naga, please take a few minutes to read the forum rules, and then edit your post to add code tags.

Thanks.