Excel combo box linked to other excel file

Hi All,

I will like to make a combo box in excel file A and linked data in excel file B. I have tried combo box properties ListFillRange='C:\Temp\[FileB.xls]Sheet1'!$C$2:$C$20 and not work if I put the Shee1 in file A with ListFillRange=Sheet1$C$2:$C$20 it will work, please help

Thank You.

Hi,

I haven't tested it but I expect that if you try to do it like that then it will only work when file B is open. You'd be better off adding a few lines of code to the userform's initialise event handler which will populate the combobox. There are examples in our Userform 101 & FAQ (http://www.xtremevbtalk.com/showthread.php?t=131000) thread.