Hellow to everyone.
Please help me.
I have this Range("A2:D4") with fruits and quantity
To load this Range in a Listbox Userform i use this code
Private Sub UserForm_Initialize()
ListBox1.RowSource = Sheets("Sheet1").Range("A2:D4").Address
End Sub
I want to know which is the vba code to put in this ListBox only the products with the quantity greater than 0 ( qant > 0 ) ?
Thank's a lot.
<tbody>
</tbody>
Please help me.
I have this Range("A2:D4") with fruits and quantity
To load this Range in a Listbox Userform i use this code
Private Sub UserForm_Initialize()
ListBox1.RowSource = Sheets("Sheet1").Range("A2:D4").Address
End Sub
I want to know which is the vba code to put in this ListBox only the products with the quantity greater than 0 ( qant > 0 ) ?
Thank's a lot.
Row/Coll | A | C | D |
1 | Product | Quantity | unit |
2 | Apples | 20 | kg |
3 | Oranges | 0 | kg |
4 | Bananas | 25 | kg |
5 |
<tbody>
</tbody>