• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Input Box

bradpallister

New Member
I am still learning the very beginning of VBA and enjoying some of the results I am coming out with.


However I am stuck with a problem where I want a multi-field input box that when you enter the info, the information is pasted into the last row (i.e. not overwriting). How do I write the VBA so that it chooses the next subsequent row?


Thanks very much
 
Brad

Sheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Offset(1).select

should do the trick for you
 
Back
Top