Interactive VLOOKUP

[GerryK]

Hi,
Can Excel (2000) display text in a set of cells when a
single cell elsewhere is clicked on once?

E.g. If I click once on A1, can text showup in AC1:AC7
from something like a VLOOKUP function which will be
specifically related to A1?
My interactive range would be A1:AB32 and my displayed
information always fixed in AC1:AC7.

I'm trying to build an interactive grid, if possible!

TIA
Gerry

 

[Vasant Nanavati]

I'm not sure what VLOOKUP has to do with what you want to do.

It's difficult to program something to happen by clicking on a cell. You can
write a macro that will be triggered by clicking on a button, or even
double-clicking on a cell.

 

[Myrna Larson]

I think MS's decision to have only a double-click event was wise. There is a
Selection_Change event and there would be no way (AFAIK) to distinguish
between that event and single-clicking a cell.

 

[Vasant Nanavati]

Hi Myrna:

I haven't thought this out fully but certainly this problem can be worked
around. Perhaps for a certain cell or range where you only want to fire the
Click event but not the Selection_Change event, an optional Boolean
parameter such as CancelSelectionChange could be used.

Regards,

Vasant.