Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need listbox to choose sheet to duplicate
Dave Peterson provided code to place a ComboBox on a toolbar to allow
you to select a sheet in the ActiveWorkbook. You could adapt the code to fit your needs. http://groups.google.com/groups?selm...&output=gplain HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- I have a workbook where we'll create one worksheet as a template and then copy it over and over within the workbook. What I'd like to do is have a listbox pop up with the sheets that are in the book to begin with, from which the user can select which sheet he would like to duplicate (I already have the code to say how many times to copy it). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting a Sheet to Choose to Display Other Sheets | Excel Discussion (Misc queries) | |||
Populating listbox with sheet names | Excel Discussion (Misc queries) | |||
Choose highest value duplicate | Excel Worksheet Functions | |||
Deleting Duplicate items in a ListBox | Excel Discussion (Misc queries) | |||
Userform Listbox using an active sheet | Excel Discussion (Misc queries) |