I have an Excel 2010 User form made up of Active X controls (text boxes and a listbox).
The listbox displays an abbreviated list of all the rows on the sheet. On opening the form the most recent record (that is, the record that appears at the bottom of the list in the list box) is displayed in the form fields.
The user can click on any record in the list box and the relevant sheet row populates the form fields.
To do this, my VBA procedure transfers the sheet data into an array and then subsequently populates the relevant text box controls and the listbox from the array.
However, if a sheet cell contained a string of more than 255 characters the application crashed. The application has now been modified to cope with this problem by using a single column MATCH function. On opening the user form the field now displays the string of more than 255 characters correctly.
But there is still a problem. If you select another record in the list box and THEN select the most recent record again from the list box, nothing happens. The most recent record is ignored.
I'm at a loss as to why this record doesn't display, other than it contains a field with more than 255 characters.
The application is attached. Click on the 'CONTRACTS' button on the sheet. The procedure in question is liContracts_Click()
Any help would be appreciated.