PDA

View Full Version : [SOLVED] Get all sheet names in comboBox of activeworkbook and export when selected



ilyaskazi
06-11-2005, 12:33 AM
get all sheet names (even hidden or very hidden sheets) in comboBox of the activeWorkbook upon loading Userform.

If the specific sheet is selected then export that sheets in already opened workbook(MyProject.xls) when 'cmdImport' button is clicked.


already posted: http://www.excelforum.com/showthread.php?t=378269

Norie
06-11-2005, 05:51 AM
Can you give some more information?

Where is this combobox located?

Where do you want to export the sheets to?

ilyaskazi
06-11-2005, 06:19 AM
comboBox is on userform

activeworkbook sheet name: ContractRecd.xls

to export in : MyProject.xls

mdmackillop
06-11-2005, 09:15 AM
This seems to have been answered at the other site. Do you need any further assistance?
MD

ilyaskazi
06-14-2005, 06:47 AM
no, thankyou.