This would be great, but I'm not using mac. Under my format menu, I don't have a control option. the only things i can see that are closely related is under the item properties where it lets you put in controlsource and rowsource. neither of these let you refer to cells in another file (at least as far as i can tell).
EDIT: sorry bout that. it works if doing it from the excel window. i was trying to do it through VBA, and they are somewhat similar, but not completely.
This message was edited by excelmacro on 2002-04-24 12:44