I would like that when an option is chosen in a list box
it changes the reference for certain cells. If the first
option is chosen then cell a4 = another workbook sheet1
cell g18 If the second option is chosen then cell a4 =
another workbook sheet2 cell b15. I tried to use the IF
formula but i guess i do may not properly understand how
to put the object into the formula. If this can be done in
VB i would apreciate that as well. Thanks for any help.

Markus