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?
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?
As ever, post the workbook.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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")
Don't forget to write your listbox to the sheet!
Semper in excretia sumus; solum profundum variat.