mouseclick events
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 |
mouseclick events
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/ |
All times are GMT +1. The time now is 12:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com