The Power of Excel : VBA listbox Datagrid- Delete selected row -PART 4

Thank you for this course and for the 3 previous ones. They are simple and very clear. Waiting for more courses.

I have a question please.
I have created a listbox from a dynamic range in another workbook. The range includes the header. When I import the range to the listbox using .List, I have the header with the body of the table not in their appropriate place (inside the rectangles at the top). I have set ColumnHeads to TRUE. What could be the reason? Thanks.

Good night.
has to put photo in product.

Super

How to show the data to listbox but the data in the other worksheet? What's coding to do it ? Thanks

START SOMETHING NEW, LIKE HR PROJECT....PLEASE

How to populate the data in list box to the text box in the user form one we select the row. Suppose I select row with I'd 3 the data should reflect in the available text box to edit?

please help me ...
how to alignment text or number in listbox columns, but only one column that aligned.and the other column in listbox not changed... for example : the first column aligned left, and the second column aligned right.
thanks

I have a question please.
Listbox i want to copy from another sheet and listbox with dropdown also want to know - 'please can you make one videos

send me demo file plz plz sir

How to edit list box items and save and update the worksheet

What is the code to find the Data Value on different sheet???

When we delete row, the serial number are missing, which is like incomplete view or missing entries. How can we retain the original serial numbers even if delete the row. Plz guide.

i follow ur rules but when i select its not delete row y can u help me

i select row on listbox its select and pression delete button come msg & but not delete row ?

Thanks ... Thanks ... Thanks

Could please create a video to delete multiple rows like you posted to delete single row.

By the way, I have tried using another For Next loop inside it. When I debug.print it gives me rows to be deleted but when it comes to to delete it only delete single row.

Thank you,

What to did

hi, can you continue this tutorial on how to search data when it comes on multiple Sheets? this will help me to finish my project. thank you .

I realize this is an older video but wondering if you can help me out. In regards to deleting a row by picking the row with this line          If Cells(i, 1) = LstDisplay.List(LstDisplay.ListIndex) Then                 I sometimes have the same data in lets say row 2 and 3 and 4....I need to match column 1 AND also column 2.  Or else it just deletes the first row with matching data. I have tried adding AND function in there but don't seem to be able to get it to work.

Hi, i don't understand why the delete code is not working with me. I follow it all. Please enlighten me on what maybe i missed?..thanks

It's not working on my project..

sir can you solve my problem?? i have generate data entry form in vba excel, all are working good, but i want to show "picture" in excel sheet according to in front of "code" how can i do??

hi, great tut. learn a lot. but there is an differents between part 3 and this part. the datagrid has now an "ID" column. now the SAVE funtion are not working proper. Can you explane how to make it work please.

Specific range delet how sir
I dont want entire row delete.

Thanks what about if i have table as listobject?how can'i selected thé item

Private Sub cmdDelete_Click()
Dim i As Integer
If MsgBox("Are you sure you want to delete this row?", vbYesNo + vbQuestion, "Delete row") = vbYes Then
For i = 1 To Range("A2:Al1000").End(xlUp).Rows
If Cells(i, 1) = ListBox1.List(ListBox1.ListIndex) Then
Rows(i).Select
Selection.Delete
End If
Next i

End If

End Sub

I keep getting Run time Error 13

Спасибо

Tank so much

I also want for the Search button

I also want for the Search button

After delete row an error is appearing

Could you share with us a gdrive file for download ? Thanks

excuse me can you teach me after delete row please show to update row number?