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.
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?
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.
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. 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.
Hi Aomar, If you will investigate further you will discover that the only way to have the headers in the appropriate positions is to use the .rowsource functionality. Otherwise you cannot have a header, this is a limitation of the VBA. As an alternative solution you can use the most common workaround for this case which is to add fixed labels at the top of the listbox. Regards,
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??
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.
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,
Thank you for this course and for the 3 previous ones. They are simple and very clear. Waiting for more courses.
Aomar Mezred I’m glad it helps :) will do
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.
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?
Tank so much
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
Most likely your punctuation on the IF MsgBox line
"Delete Row" = vbYes) Then
vs.
"Delete Row") = vbYes Then
Thanks what about if i have table as listobject?how can'i selected thé item
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.
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.
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.
Hi Aomar, If you will investigate further you will discover that the only way to have the headers in the appropriate positions is to use the .rowsource functionality. Otherwise you cannot have a header, this is a limitation of the VBA. As an alternative solution you can use the most common workaround for this case which is to add fixed labels at the top of the listbox. Regards,
Thanks a lot for your answer. How to add these fixed labels?
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??
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.
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 .
How to show the data to listbox but the data in the other worksheet? What's coding to do it ? Thanks
Specific range delet how sir
I dont want entire row delete.
Could you share with us a gdrive file for download ? 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
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,
How to edit list box items and save and update the worksheet
I also want for the Search button
What is the code to find the Data Value on different sheet???
i select row on listbox its select and pression delete button come msg & but not delete row ?
excuse me can you teach me after delete row please show to update row number?
but my data is in table form.how i delete it in table form?
ME TOO
i follow ur rules but when i select its not delete row y can u help me
Спасибо
After delete row an error is appearing
It's not working on my project..
Super
Good night.
has to put photo in product.
Thanks ... Thanks ... Thanks
What to did
send me demo file plz plz sir
START SOMETHING NEW, LIKE HR PROJECT....PLEASE
I also want for the Search button