ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I have a cell highlight when selected? (https://www.excelbanter.com/excel-worksheet-functions/112477-how-do-i-have-cell-highlight-when-selected.html)

Rhonda

How do I have a cell highlight when selected?
 
How can I have a cell highlight when it's selected. Whether I use the tab or
arrow key to get to the cell throughout the spreadsheet, is there a way to
have it automatically highlight (in any color) once selected?

Gary L Brown

How do I have a cell highlight when selected?
 
It does highlight with a big black rectangle around it. What else do you want?
You could put something in the Worksheet_SelectionChange event or create a
workbook class.
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Rhonda" wrote:

How can I have a cell highlight when it's selected. Whether I use the tab or
arrow key to get to the cell throughout the spreadsheet, is there a way to
have it automatically highlight (in any color) once selected?



All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com