Automatic update of list box with named range

[El_engineer]

I am using a userform with a list-box, populated by a range. The range is given by Offset and the formula works.
The problem is when I insert a row through my form, the content of the list box is not updated. If I close the form
and I open it again it works and the new row appears. How can it be updated automatically?

[Tinbendr]

You'll just have to refresh the listbox.

In the Worksheet_Change event, clear and reload the list.

Use this function to check if the userform is loaded.

Please Login or Register  to view this content.

[El_engineer]

Thanks for the answer. I did the following inside the button code:

Please Login or Register  to view this content.

I am a little confused with Worksheet_Change event. Is it called automatically when something changes in your cells in the sheets?
Because I tried it a bit it didn't work (most likely I had something wrong).

[Tinbendr]

The code has to be on the sheet code page where the list resides.

So, if your list is on Sheet1, so does the code have to be in the Sheet1 code page.

[El_engineer]

Thanks. Do you know if there is a way to make a macro run automatically in case of an event?
I have created a macro and you have to click on a button once you have filtered a table, in order to run it. Can it be called automatically upon filtering the table,
without clicking on the button?

[Tinbendr]

Probably the best way to handle that is to have the macro to run the filter selection, then update the listbox afterward.