Is the userform being shown modally? If so, why not just load the list each
time you show the form?

Tim


"tr00per" wrote in message
oups.com...
Hello everyone. Thanks for all your help in the past, and hopefully
someone will be able to get me pointed in the right direction with this
problem too.

I have a userform containing a listbox. the listbox is loaded with the
sheetnames of the workbook. How can I know when/if the user changes
the worksheet names, so that I will then know to update the values of
the listbox so that the listbox always contains the current list of
sheetnames?

Any help is greatly appreciated.

Thanks in advance, and happy programming!

Troy