combo box doesn't work in excel 2003
 

hi there

I created a combo box (drop down menu) in a form using Excel 2002.

this combo box got it's values from a file like this
[file.xls]months!$A$1:$A$14

it works fine in Excel 2002. but when I run that macro in Excel 2003
nothing appears in the drop down menu.. .it's as if the referece to
[file.xls]months!$A$1:$A$14 does not work.

any clue as to why that would be in 2003?

thanks

Pabs


--
pabs
------------------------------------------------------------------------
pabs's Profile: http://www.excelforum.com/member.php...fo&userid=3962
View this thread: http://www.excelforum.com/showthread...hreadid=504104