Create list of selected worksheet names

[Groovicles]

Hi everyone,

I have two workbooks, workbook1, and workbook2. Workbook1 has the macro.

All I'm trying to do is have a macro so that the user will select any worksheets he/she wants in workbook2 and the names of those worksheets will be copied to workbook1, sheet1, range("P3").

Not trying to copy all worksheet names, only the ones that the user selected.

Any ideas?

Thanks!!

[mehmetcik]

Create a userform.

All it needs have is one textbox, one listbox and one command button.

put the name of workbook two in the Textbox

the Listbox is loaded with all the sheet names in workbook two.

Select one or more lines on the listbox

Click on the command button.

The Selected names are saved on workbook One.

[Groovicles]

Hi mehmetcik,

The 2nd workbook is random. A list box with pre-determined worksheet names would not work. Thanks for your suggestion though.

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[Sintek]

You can try this: A Userform with a listbox.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Groovicles]

Hi Alpha,

Thank you. Your macro works great, however I needed the list worksheet names to go down the column starting from P3. Apologies if I wasn't clear enough.

[Sintek]

Workbook1 has the macro. All I'm trying to do is have a macro so that the user will select any worksheets he/she wants in workbook2 and the names of those worksheets will be copied to workbook1, sheet1, range("P3").

Did I misunderstand...Are you not wanting to open Workbook2 then select worksheets whose worksheet names must be populated in P3, P4, P5 etc

[mehmetcik]

I decided to use One LISTBOX, One COMBOBOX and one command button.

The Combobox allows you to select any open workbook you want.

Please Login or Register  to view this content.

[AlphaFrog]

Hi Alpha,

Thank you. Your macro works great, however I needed the list worksheet names to go down the column starting from P3. Apologies if I wasn't clear enough.

Please Login or Register  to view this content.