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
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.