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
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
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