Inkey equivilent

Hello this is my first post on this forum.

Could any of you knowledgable ones tell me of an equivilent of BASIC "inkey" or "get" functions that can be used on an Excel spreadsheet ?

Cheers Jim

Without answering your question , what are you trying to do with Excel that would need those functions?

Originally Posted by shg

Without answering your question , what are you trying to do with Excel that would need those functions?

Well roughly speaking I want to click an item in a big list and automaticaly open up another list connected to the item. Or press a key on the keyboard and have a similair effect.

Also I want to click on certain cells and leave a mark such as "X" or "?" as opposed to typing an "X" then return.

I have done this program before in BASIC but find not being able to use the above methods a stumbling block.

Sorry to be so vague but it's the best way I can explain it.

Excel has events that can trigger code based on changing the cell selection, double-clicking on a cell, or changing one or more cells -- ample unto your needs.

Hello JimJim,

VBA doesn't have an a equivalent intrinsic function like InKey$. As Shg points out, the code does have events but there aren't any that would work in the way InKey$ does. To examine a key as it is typed before Excel can interpret it, is anything but simple.

There a very few similarities between BASIC and VBA. It would be better if you could give a more detailed example or explanation of what you want to do. Perhaps then when can cross translate the functions for you.

Sincerely,
Leith Ross

Cheers to you both for taking the time to answer my question.

My main concern was to whether the above functions existed, now I know they do not I will pursue the alternative methods as described by yourselves,

I'm sure I will succeed eventually.

Again thanks Jim