Interactive VLOOKUP

  • Thread starter Thread starter GerryK
  • Start date Start date
G

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
 
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.
 
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.
 
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.
 
Back
Top