Combobox with Sheet Names

[smartbuyer]

Hi,

Is there a way to refresh the combobox list in a userform when user changes a worksheet name?

I have this code that lists all the sheet name in the combobox

Please Login or Register  to view this content.

Thanks!

[mehmetcik]

Your user form is dynamic so it is reading the existing sheet names.

Are you suggesting you are changing the sheet name while the file is open?

If so all you do is delete the sheet name from the user form and add the new name or maybe run the macro again.

Try this:-

Please Login or Register  to view this content.