Thank you for this course and for the 3 previous ones. They are simple and very clear. Waiting for more courses.
@mariusavram1468
6 жыл бұрын
Aomar Mezred I’m glad it helps :) will do
@user-gl1el2ov5b
Жыл бұрын
Tank so much
@angelodeocampo3643
4 жыл бұрын
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
@wattjock2405
3 жыл бұрын
Most likely your punctuation on the IF MsgBox line "Delete Row" = vbYes) Then vs. "Delete Row") = vbYes Then
@excel-k-sir
6 жыл бұрын
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?
@stevecartier2904
5 жыл бұрын
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.
@hwangcesiung8979
6 жыл бұрын
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
@asadost258
5 жыл бұрын
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.
@fransgroeneweg9575
4 жыл бұрын
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.
@samnangsuonsokunth8719
5 ай бұрын
excuse me can you teach me after delete row please show to update row number?
@ameurchabane6001
4 жыл бұрын
Thanks what about if i have table as listobject?how can'i selected thé item
@zaibakela
4 жыл бұрын
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??
@kalumohanty8738
5 жыл бұрын
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,
@user-gl1el2ov5b
Жыл бұрын
I also want for the Search button
@rachmanramadhan3307
6 жыл бұрын
How to show the data to listbox but the data in the other worksheet? What's coding to do it ? Thanks
@shoaib8490
5 жыл бұрын
i select row on listbox its select and pression delete button come msg & but not delete row ?
@ashokadigoppua7945
4 жыл бұрын
Specific range delet how sir I dont want entire row delete.
@MunawarFairooz
5 жыл бұрын
How to edit list box items and save and update the worksheet
@charlesarticona5318
5 жыл бұрын
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 .
@nikistro8424
5 жыл бұрын
What is the code to find the Data Value on different sheet???
@MohAboAbdo
5 жыл бұрын
Thanks ... Thanks ... Thanks
@mangalhansda571
Жыл бұрын
After delete row an error is appearing
@flackvanderdutch3081
10 ай бұрын
Could you share with us a gdrive file for download ? Thanks
@shoaib8490
5 жыл бұрын
i follow ur rules but when i select its not delete row y can u help me
@mohamedhasanbasari
6 жыл бұрын
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
@joshbalamban8734
6 жыл бұрын
but my data is in table form.how i delete it in table form?
@gannsebastianquiban5060
4 жыл бұрын
ME TOO
@user-xw9dr6ui9o
3 жыл бұрын
Спасибо
@IglanTube
6 жыл бұрын
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.
@mariusavram1468
6 жыл бұрын
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,
@IglanTube
6 жыл бұрын
Thanks a lot for your answer. How to add these fixed labels?
Пікірлер: 44