ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Color Indicator (https://www.excelbanter.com/excel-programming/296950-color-indicator.html)

bob

Color Indicator
 
Is there a means of changing the color of box indicator in
which the cell you move to is diferent. Another words
everytime you move to another cell the cursor which is a
standard black outlined can be changed. Thanks for your
help, hope this was a descriptive enough question.

Dave Peterson[_3_]

Color Indicator
 
Chip Pearson has an addin that will do what you want (and more):
http://www.cpearson.com/excel/RowLiner.htm

The biggest drawback is that like most macros, this disables the Undo feature.

Bob wrote:

Is there a means of changing the color of box indicator in
which the cell you move to is diferent. Another words
everytime you move to another cell the cursor which is a
standard black outlined can be changed. Thanks for your
help, hope this was a descriptive enough question.


--

Dave Peterson


JMay

Color Indicator
 
If you mean you want the activecell to constantly be say "Yellow", then
paste the following into the module named Thisworkbook:

Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)
On Error Resume Next
Sh.Cells.Interior.ColorIndex = xlColorIndexNone
Target.Interior.ColorIndex = 6 ' yellow - change as needed
End Sub


"Dave Peterson" wrote in message
...
Chip Pearson has an addin that will do what you want (and more):
http://www.cpearson.com/excel/RowLiner.htm

The biggest drawback is that like most macros, this disables the Undo

feature.

Bob wrote:

Is there a means of changing the color of box indicator in
which the cell you move to is diferent. Another words
everytime you move to another cell the cursor which is a
standard black outlined can be changed. Thanks for your
help, hope this was a descriptive enough question.


--

Dave Peterson





All times are GMT +1. The time now is 09:05 AM.

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