Dynamic ListBox Row Source

Hello,

Currently I have a UserForm containing a listbox that I have populated from A2:A185. Each week, names are added and removed from column A, and I would like to find a way to have the Listbox row source updated each time it is called (instead of having it static at A2:A185).

If needed, the sheet I am working from is called "Summary".

If someone could assist me with this, it would be greatly appreciated.

Best,

Grazian2

Try this in the Userform Module:-

Please Login or Register  to view this content.

Spooky !!!!!!!

MickG, you're code did the trick!

Thank you to both of you for your responses!

Best,

Grazian2