something like this
or maybe for each window in windows
try recording a macro and just select different workbooks and see what the
code turns up then use it as below

dim wb as workbook
for each wb in workbooks
combobox.item.add wb.name
next

"JasonSelf" wrote:


I am looking to create a combobox that has a list of every currently
open workbook in excel. what property would I need to pull to do
this? Would I need to use an array?

Thanks,
Jason


--
JasonSelf
------------------------------------------------------------------------
JasonSelf's Profile: http://www.excelforum.com/member.php...fo&userid=5330
View this thread: http://www.excelforum.com/showthread...hreadid=467950