ListBox refuses to repopulate after selection change

Hi,

How do I automatically update a ListBox on a UserForm after changing a TextBox whose value is on that ListBox?

I have two UserForms, Userform1 requires the user to click an "Amend Record" button to update the ListBox (and the underlying database). That works perfectly (it's on sheet "Database"). But now I need to make the updates without having to press any buttons. The ListBox (on Userform2") and Database2 need to update automatically. And I have been successful with all the controls except for the one whose value appears in the ListBox.

Whenever I mention that control ("txtName") in the code, the ListBox refuses to populate itself whenever a user changes a ListBox selection. The problem seems to be that the code runs the populate macro when the form is initialized, but then when a ListBox selection is made, the code reads the List range range as empty.

I've tried all sorts of solutions to get the list range to be read again, but no luck. What do you think?

Lawrence

RoyUK,

Which complicated range names? All of the range names used in the macros refer to single cells except for the dynamic range referring to the database, "ListItemsRange2".

If I replace the dynamic formula with a fixed range, I still get the same problem of the ListBox not repopulating.

Slow? That's wierd! It's getting suck on rngMove on the spinner macro...never did that before. I'll try to resolve that.

What do you think is the issue with repopulating the Listbox?

Lawrence

Originally Posted by royUK

Your code seems to run extremely slowly.

The Named Ranges seem to be created with complicated formulas? Why?

I can't see why you need those names to populate the ListBoxes

Okay, I rebooted my PC and now I do not experience any lag.

Wish I knew what lag you were experiencing.

Any ideas on the populating ListBox issue?

Lawrence

...Bump...