List Box

[Becky]

Hello

I have a 4 column list box that is populated by 4 text boxes. When I click on a row in the list box it repopulates the text boxes for editing. When I try to update the row in the list box with the edited data I use

lstCloseOut.List(lstCloseOut.ListIndex, 0) = cmbVendorNam
lstCloseOut.List(lstCloseOut.ListIndex, 1) = txtVendorAddress
lstCloseOut.List(lstCloseOut.ListIndex, 2) = txtVendorAddress
lstCloseOut.List(lstCloseOut.ListIndex, 3) = txtVendorAddress

When the first line executes it jumps to the list box Click event. It does not do that for any of the other lines, only when the column is 0. I don't know why it is doing this. Is there a work around for this

Any help is appreciated

B

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Becky,

To avoid this happening, put the commands to re-populate the textboxes into
the

Private Sub lstCloseOut_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
event

and delete the Private Sub lstCloseOut_Click() event

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP