Drop down list to select sheet name

Will the number of sheets and the sheet names be static or dynamic? Also, will you want the list to include all sheets, or just certain ones?

Hi natefarm,

Thanks for the response! The number of sheets and sheet names will be dynamic. Each time they receive the current input box they are adding a new sheet. I want the list to include a list of names they can select to name each new sheet. I do not want the user to manually enter the sheet name.

InputBox is a built-in function, but list boxes have to be created and built. I have attached an example where the user is prompted with a user form that includes a list box showing all worksheet. The user selects a sheet then clicks OK to go to that sheet, or Cancel to cancel. A Sub called Test shows the form.

I misread your initial post. My macro allows the user to select an existing sheet, not select a name to be applied to a new sheet.

You still need a list box. How are you going to determine what the list should be?

I have a defined list they will be able to choose from to name each sheet. I have defined the range "forecast version". Is there a way to use this defined range in the macro?

Somewhere in your worbook, enter the list of names in a range, and name it NameList. Then from the Developer tab, insert an ActiveX Combobox in the desired location, and in the Properties, enter "NameList" in the ListFillRange. Right-click the combo box and select View Code. Then in the ComboBox1_Change event that it creates, put the following:

Please Login or Register  to view this content.

There are other things you can do with it, but that should get you startede.