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
Printable View
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
Code: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