ListBox Text appears then disappears

palaeontology

Active Member
Joined
May 12, 2017
Messages
371
Office Version
  1. 2016
Platform
  1. Windows
I have a UserForm with a ListBox that is populated from a row source reference .... IndivStudentSelect!V14:w44

When a student name is clicked from inside that ListBox list, the chosen student name is supposed to appear in the following Control Source reference ... IndivStudentSelect!AH15

Obviously, in the ListBox properties display, the student name that was clicked on, appears beside the property called .... Text

This Userform (and Listbox) has worked for several years and no changes have been made to the spreadsheet to which the UserForm is related.

However, in the last 12 hours, the student name will appear beside the property called Text (as it should), but disappears after 5 seconds.

Here's an image of the relevant component of the ListBox properties display when the name is correctly displayed beside the property called Text ...

1592455977268.png


And here's an image of the name having disappeared 5 seconds later

1592455856613.png


It has never done this before, but is a big problem now, as it no longer displays in it's allocated Control Source location, so all features of the userform that rely on a name appearing there, no longer work.

Does anyone have an idea why this might have started happening, and if so, what can I do to fix it ?

Kind regards,

Chris
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
We would have to check the properties of the userform and the file.
You could upload a copy of your file to a free site such www.dropbox.com or google drive. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,776
Messages
5,544,155
Members
410,595
Latest member
Tatum2020
Top