hello
I search for code to copy showed data in textboxes and listboxes when search on userform. so when I put item in textbox1 based on column 4 then it will show data in textbox2,3 and the listbox. should copy to sheet print (textbox1=A2,textbox2=B2,textbox3=C2) and the data in listbox contains 8 columns should begins from row4 with considering when print the data should ignore any empty row contains borders .
I search for code to copy showed data in textboxes and listboxes when search on userform. so when I put item in textbox1 based on column 4 then it will show data in textbox2,3 and the listbox. should copy to sheet print (textbox1=A2,textbox2=B2,textbox3=C2) and the data in listbox contains 8 columns should begins from row4 with considering when print the data should ignore any empty row contains borders .
| search on userform (2) (1).xlsm | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 1 | ID-CC | QTY | TOTAL | |||||||
| 2 | ||||||||||
| 3 | INVOICE NO | ID-CC | BB-R | TT-Y | OR-GG | QTY | PRICE | TOTAL | ||
| 4 | ||||||||||
| 5 | ||||||||||
| 6 | ||||||||||
| 7 | ||||||||||
| 8 | ||||||||||
| 9 | ||||||||||
| 10 | ||||||||||
| 11 | ||||||||||
| 12 | ||||||||||
| 13 | ||||||||||
| 14 | ||||||||||
| 15 | ||||||||||
| 16 | ||||||||||
| 17 | ||||||||||
print | ||||||||||
