PDA

View Full Version : [SOLVED] Clear all items in listbox column



av8tordude
05-31-2020, 12:37 AM
I have a userform that display items in a listbox. In Column 4 of the listbox have prices. I want to be able to use a button to make this column all $0.00's. Can a VBA code accomplish this task?

Thanks you

mana
05-31-2020, 02:36 AM
Dim v
Dim k As Long


v = ListBox1.List
For k = LBound(v) To UBound(v)
v(k, 3) = "$0.00's"
Next
ListBox1.List = v

av8tordude
05-31-2020, 02:42 AM
Thank you Mana...I sincerely appreciate your help!





Dim v
Dim k As Long


v = ListBox1.List
For k = LBound(v) To UBound(v)
v(k, 4) = "$0.00"
Next
ListBox1.List = v



OMG...thank you so much