Hi,

this is a very simpy question (and what bugs me I used to know the answer, but I have forgotten it and can't remember).

I want to create a comboBox in Excel and then display the contents of other cells dependend on what I have chosen in the comboBox.

Basically it would be a case where the cell displaying the result would have something like this:
=Ji
J being the column (constant)
i being depended on the result in the 'cell link' field.

J1 would contain the first information being chosen
J2 the second and so forth

Right now Excel doesn't recognize the 'i' as a variable and complains (how do I tell it that it is one?)

Thanks, PJ