PDA

View Full Version : [SOLVED] update listbox



av8tordude
05-06-2020, 03:21 AM
How can I update the selected line in a listbox with the new info?
Also, Instead of the word "Open", how can I insert numbers (i.e. 1 ,2, 3, etc) next to each row in the listbox?

Bob Phillips
05-06-2020, 03:30 AM
As ever, post the workbook.

av8tordude
05-06-2020, 04:15 AM
I figure it out...thank you



.List(.ListIndex, 0) = cbox.Caption .List(.ListIndex, 1) = txtbox1
.List(.ListIndex, 2) = Format(txtbox2, "$0.00")
.List(.ListIndex, 3) = Format(txtbox3, "$0.00")

paulked
05-06-2020, 04:19 AM
Don't forget to write your listbox to the sheet!

av8tordude
05-06-2020, 05:07 AM
Don't forget to write your listbox to the sheet!

Already coded. thx :thumb