I have data in sheet4 (contains 8 columns), I need to populate my list box using criteria from my textbox1
After populating my listbox I will select the cell or data that I need to edit (From the Listbox) and save it on my worksheet.
SAMPLE DATA
<tbody>
</tbody>
SAMPLE LISTBOX below, based on my criteria from my textbox1 = 145 (column A)
here if i will edit something (except column A) I want the changes to be save/replace the previous data.
<tbody>
</tbody>
Thank you in advance.
After populating my listbox I will select the cell or data that I need to edit (From the Listbox) and save it on my worksheet.
SAMPLE DATA
A | B | C | D | E | F | G | H | |
1 | 123 | XXX | 12 | 12S | CFDS | GRE | FFF | GD |
2 | 123 | DFA | 55 | 32SA | GAS | ADFG | SSS | GS |
3 | 123 | GASD | 245 | 21FSD | AG | DGA | EEE | VB |
4 | 145 | ASDGA | 585 | 1AS | BA | ADG | AAA | DF |
5 | 145 | HFSDF | 4 | 2GH | AS | ADG | DDD | GD |
6 | 222 | SHDFE | 64 | 51SD | GR | HSD | JJJ | TE |
7 | 222 | ERRT | 33 | 24FS | SDRD | DS | KKK | EW |
8 | 222 | HFS | 24 | 25S | HRE | SDF | GGG | WE |
9 | 555 | RTHFS | 24 | 64FA | DGT | SDFH | RRR | FT |
11 | 555 | TRER | 24 | 2FSAD | SDG | ERH | WWW | JH |
<tbody>
</tbody>
SAMPLE LISTBOX below, based on my criteria from my textbox1 = 145 (column A)
here if i will edit something (except column A) I want the changes to be save/replace the previous data.
145 | ASDGA | 585 | 1AS | BA | ADG | AAA | DF |
145 | HFSDF | 4 | 2GH | AS | ADG | DDD | GD |
<tbody>
</tbody>
Thank you in advance.