I have a list of names I need to go through. I would like to make
macro that, when activated, highlights the names I choose in a color.
Formatting the cell is no problem, but how do I make VBA recognize
mouseclick in a certain cell

--
Message posted from http://www.ExcelForum.com

You can use the selectionchange event, but that will fire whenever a cell is
selected, regardless of how it was selected (tab, return, mouseclick).

If you want to be more specific, you can use beforeRightclick or
BeforeDoubleClick events.

See Chip Pearson's site for information on events if you are not familiar
with them

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"animal1881 " wrote in message
...
I have a list of names I need to go through. I would like to make a
macro that, when activated, highlights the names I choose in a color.
Formatting the cell is no problem, but how do I make VBA recognize a
mouseclick in a certain cell?


---
Message posted from http://www.ExcelForum.com/