Using VBA to Enter Data into an Excel Table

Watch this video to learn how to use VBA to Enter Data into an Excel Table using Microsoft Excel. In this VBA to Enter Data into an Excel Table tutorial, you are going to learn a few basic tips for entering data very quickly!

This is a great video for Beginner or Intermediate Excel users and it shows another way to do data entry to an Excel table with an introduction to writing VBA code.

This Using VBA to Enter Data into an Excel Table tutorial was recorded using Microsoft Office 365.

⌚ Time Stamps:
00:00 - Introduction
00:36 - Spreadsheet Description
01:01 - Saving an Excel File with VBA Code in it
01:35 - Data Validation
03:22 - Adding the Developer Ribbon
04:02 - Creating Active X Controls (button)
05:08- Writing Code
12:02 - Testing Code
12:53 - Preview of Next Lesson
13:32 - Review
------------

🔥 OUR BEST EXCEL RESOURCES 🔥

👨‍🏫 Get 30+ Excel & Office Courses & support for ONLY $1💵 (all levels covered)
Learn Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams, Project, PowerApps, PowerAutomate, Visio, Forms & MORE!

📚 Download Our Free 101 Excel Tips & Tricks E-Book:

💻 Access 1,000+ Free Excel & Office tutorials over at our award-winning blog:

📚Get All Our 101 Excel E-Book series on Formulas, Macros & Pivot Tables:

📚101 Most Popular Excel Formulas Paperback on Amazon:

📚101 Ready To Use Excel Macros Paperback on Amazon:

📚101 Best Excel Tips & Tricks Paperback on Amazon:

👷 Excel Consulting Services:

💻 Looking for more Microsoft Excel & Office tutorials? Check out our playlist below:
------------

Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!

If you enjoyed the video, please give a thumbs up, comment, share.

Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)

Cheers,

JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP

❤️ Let’s connect on social ❤️
#MyExcelOnline #MsExcel #VBA #Excel

[amilarambukwella]

I was in tremendous trouble until this was found. This reduced time-wasting over data segregation. Simply
saved my day

[TradShowTom]

On a scale of 1-10 of VBA knowledge I'm probably about .3. All the examples I've seen to add a new line of data to a table seem overly complicated but this was very simple and easy to learn. I created an actual form for my input so I had to make some minor changes but it works like a champ. Thank you for posting this.

[ponpandianm]

looking for this step in my excel for the past few days ..finally found the perfect solution and it's working fine ....thanks a lot to u team <3

[amilarambukwella]

Though almost after a year, this is very loud and clear, as any beginer could understand, no waste of time. Appreciate it.

[FretMillen]

I was looking for this year's ago and now I'm looking for it again. Thank you. Definitely following this channel!

[azolotaiko]

THANK YOU!!! I’ve looking for this for months! 🙏

[carabrookins]

So clearly explained and exaclty the simple solution I was looking for. Easy to execute and expand even though I'm a newbie. Thank you!

[patrickschardt]

I don’t use VBA a lot. That being said, this tutorial is fantastic

[brunobb]

Thank you so much for this! I knew 0 about Excel in general and this video really helped me out with work!

[ashwinsanjiv]

Very clear. Thanks for helping by posting this video.

[GLOCKS_CAL]

Very clearand defined guidance. Thank you.

[assafadr]

mind blowing !, awesom lesson. thank you very much

[simpliside]

This is remarkable by all standards. Keep up

[RPatt-lu]

Thank you so much! What a great help this was.

[francobertoli]

This is a great tutorial, thanks. But I keep getting an run time error 9. When I look at the vba, the set myRow is highlighted yellow and if I hover the mouse over it, it says myRow = nothing. I have tried it with different workbooks and I get the same error. I cant work out how to fix this.

[daniellamendola]

How could I have the cell in the first column auto-increment up one number from the previous row (or up one from the highest number in the existing table), to basically create a primary key as the table expands?

[bertiebassett]

This video was great and extremely helpful, but I was wondering if I could ask for a little more assistance? I need to add the data to a row but maintain the formula within specific cells. For example, when you use the formula "myRow.Range(1)=Range("B2")" this would take the information as it appears in the cell and enter it exactly, even if there was formula in the cell. Essentially it pastes values and not formulae. Is there a way to do this?

Every other method I have looked at to do this deviates massively from what you have done to enter the row so getting them to match up is difficult, especially as my understanding of VBA code is extremely limited. Thanks :)

[lfzsvrz]

This is a great walkthrough that I've been looking for. When I try to follow your example, my data doesn't go to the bottom of the table. It is inserted in random places. Do you know what would cause this? (I'm just learning VBA)

[SalsaEdits]

If I highlight the data in my table --> delete it --> resize table back to where it started --> run code again

I am getting a:
"Run-time error '9':"
"Subscript out of range"

I think it's because the cell it is trying to put the new record in is now out of the tables bounds after being resized.

[jamescarty]

Hi, what if if someone inserts a new row within the table defects wont this mess up the data output? How do I stop this from happening? Will I need to create individual data tables and call each one so the data never gets broken?