Excel VBA - How to use Excel Table in VBA

Рет қаралды 7,597

3 жыл бұрын

In this video you will learn how to use Excel table in VBA. After watching video you will understand -
1. Different parts of Excel Table.
2. How to select Excel table and different parts in VBA
3. How to add column/ Rows in Excel table in VBA
4. How to add/ update data in excel table in VBA
5. How to delete row/ column of Excel table in VBA
6. How to search data in excel table in VBA
7. How to apply filter in excel table in VBA.
File to Download:
drive.google.com/file/d/17ySJ...
To open a user form which transfer data to table:
drive.google.com/file/d/1p3YA...
SUBSCRIBE: kzfaq.info...
#ExcelSessions #Excel #MSExcel #MicrosoftExcel #ExcelSession

Пікірлер: 28

@redhaakhund1271 6 ай бұрын

👍👍👍👍👍

@querrythis 6 ай бұрын

I like the comprehensive explanation. It helps so much in understanding how it works.

@SessionsbySaurabh 6 ай бұрын

Thanks a lot for your words.

@wejrd_ Жыл бұрын

Thank you for this tutorial. After looking for solution for my problem for about 4 hours today, you explained everything about tables for me in 15 minutes. Impressive.

@SessionsbySaurabh Жыл бұрын

Thanks a lot for your words.

@cidscala 11 ай бұрын

Excellent! Congrats, professor!

@SessionsbySaurabh 11 ай бұрын

Thanks

@iliesmeziani 8 ай бұрын

Merci beaucoup c'est très utile

@keithspinner5970 2 ай бұрын

Thank you for clearly explaining some of the mysteries of tables! How do you go about finding which column “Age” is as a variable and then using the variable in the code?

@SessionsbySaurabh Ай бұрын

Hi, use below code to find “Age” column Dim mytable As ListObject Dim col_no As Integer Set mytable = ActiveSheet.ListObjects("myTable") 'To get the column number of "Age" column col_no = mytable.HeaderRowRange.Cells.Find("Age").Column 'To select the age column mytable.ListColumns(col_no).Range.Select

@TheJaebeomPark 5 ай бұрын

interesting! thanks

@SessionsbySaurabh 5 ай бұрын

Thanks

@relaxingtown4all440 2 жыл бұрын

Excellent and very easy. thank you

@SessionsbySaurabh 2 жыл бұрын

Thanks. Your words made my day.

@relaxingtown4all440 2 жыл бұрын

@@SessionsbySaurabh I joined your channel because I like your step by step method. easy understandable. can you please explain how to add a linked chart to a database table in a VBA form

@bob-tina Жыл бұрын

Heel duidelijk uitgelegd. dankjewel

@SessionsbySaurabh Жыл бұрын

Thanks Bob

@stanTrX Жыл бұрын

Very helpful, thank you 😊

@SessionsbySaurabh Жыл бұрын

Thanks

@andyv123 Жыл бұрын

Very useful. Thanks. Is there a quick way to append data to a data table. I.e combine two tables together? Very inefficient to add row by row and column by column

@SessionsbySaurabh Жыл бұрын

To copy data from one table to another, we can use below VBA. Let me know if It resolves the issue. Hope I understood the problem correctly. Sub copyDataFromAnotherTable() Dim myTable As ListObject Dim newRow As ListRow ''''''''mainTable is table name. Set myTable = Worksheets("Sheet1").ListObjects("mainTable") Set newRow = myTable.ListRows.Add '''''''''''''copy data of table. TableToCopy is table name. Worksheets("Sheet2").Range("TableToCopy").Copy '''''''''Paste the data in new row newRow.Range.PasteSpecial xlPasteValues End Sub

@anshuljain6127 3 жыл бұрын

This is going to help a lot

@SessionsbySaurabh 3 жыл бұрын

Thanks

@stanTrX Жыл бұрын

Thanks again, one question, why shall we define the table in activesheet, what happens if its in a different worksheet. Is there a way to call it without referring it's sheet number?

@SessionsbySaurabh Жыл бұрын

Hi StanTR, you can call any sheet as below: Set mytable = Sheets("data").ListObjects("myTable") here, "data" is sheet name which contains the table and "myTable" is table name.

@kamranmammadov9546 11 ай бұрын

Thanks for the information. Can you help to pass the data in the listbox to the table? Thanks in advance

@SessionsbySaurabh 11 ай бұрын

Hi, I uploaded a file where user form is used to add/update/delete data from table. Please check if it helps you. drive.google.com/file/d/1p3YAcnYiLXJIrWYgz5XziTQ0R2Zrw7mz/view?usp=sharing