Userform List Box not updating
Posted by Gary Hewitt-Long on December 23, 2001 12:59 AM
I have a userform which has a listbox which is linked to a sheet of data. Part of the forms job is under certain circumstances to delete a row of data. When this happens though the listbox still shows that data unless the form is closed and then re-opened.
Is there a way of making sure the listbox updates itself to only show what is actually in the sheet it is linked to?
It won't let me use Listbox1.update??