Clear all items in listbox column

[av8tordude]

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]

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]

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