Read Keyboard Buffer ?
 

I have an application in which a cell is selected. I trap this with a
worksheet selection change event. Within the macro I need to take separate
actions if the cell was selected with the arrow keys or a mouse click.

Is there any way to determine how I got there!

Thanks in Advace for help help or clue.
--
Gary's Student

Read Keyboard Buffer ?
 

Hi,

There's no different between selecting cell with mouse
and with arrow key up/down.

Let me guess that you want to know that the mouse over
cells.

Use GetCursorPos API calls...


Regards,

Halim


Gary''s Student menuliskan:
I have an application in which a cell is selected. I trap this with a
worksheet selection change event. Within the macro I need to take separate
actions if the cell was selected with the arrow keys or a mouse click.

Is there any way to determine how I got there!

Thanks in Advace for help help or clue.
--
Gary's Student

Read Keyboard Buffer ?
 

To the best of my knowledge, Excel does not natively expose such a
different.
But you additionally have the other means of "arriving" at a cell:
- Goto
- Hyperlink
- Code
- Undo
- From the Name box
Why is necessary to determine how the user arrived there ?

NickHK

"Gary''s Student" wrote in message
...
I have an application in which a cell is selected. I trap this with a
worksheet selection change event. Within the macro I need to take
separate
actions if the cell was selected with the arrow keys or a mouse click.

Is there any way to determine how I got there!

Thanks in Advace for help help or clue.
--
Gary's Student