How To Enter A Value In The Next Empty Row Using VBA - The Excel Hub

In our sheet we have a list of student names and want to create a macro which first identifies the next empty row, then gives the user the option to input a name through an input box and finally inputs the name correctly. The macro will consist of two variables - a variable to identify the next empty row and a variable to insert the name in that row.

Access the templates featured in The Excel Hub's video tutorials here:

Subscribe for weekly Excel tutorials, techniques and examples:

Please share this video with others that may find it useful:

Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!

ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.

For any enquiries, please contact:

Overview: (0:00)
Build Macro: (0:27)
Test Macro: (1:45)

[Krysda]

THanks. What if you want the input for the new student name to be a cell somewhere on the sheet (same sheet)?

[bookmaster]

Thx. What if i use a button not like u, how shoud i do?

[lmac]

how would someone do this in google sheets?

[JordanShafen]

Empty_row = isn't working saying soimthing is wrong with Cells

[cthullhufhtagn]

Not everyone has good internet and large screens. Low quality and on mobile, plus no coding included in description, means the video cannot be followed. Coding isn't really forgiving when trying to decipher pixilated text.