Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Cursor row and column

Hi
Is there any way to get colours to the row and to the column where the
cursor is. They should change every time when moving the cursor. Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,124
Default Cursor row and column

Right click sheet tabview code insert this

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Cells.Interior.ColorIndex = 0
With ActiveCell
.EntireRow.Interior.ColorIndex = 36
.EntireColumn.Interior.ColorIndex = 36
End With
End Sub

--
Don Guillett
SalesAid Software

"Reedhill" wrote in message
...
Hi
Is there any way to get colours to the row and to the column where the
cursor is. They should change every time when moving the cursor. Thanks!



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Cursor row and column


you may want to try Chip Pearson's Rowliner:
http://www.cpearson.com/excel/RowLiner.htm

Reedhill wrote:

Hi
Is there any way to get colours to the row and to the column where the
cursor is. They should change every time when moving the cursor. Thanks!


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Cursor row and column

Thanks both of you. They worked fine.

"Reedhill" kirjoitti:

Hi
Is there any way to get colours to the row and to the column where the
cursor is. They should change every time when moving the cursor. Thanks!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why can't I CONSISTENTLYmove cursor from first column to last colu dk Excel Discussion (Misc queries) 2 May 11th 09 05:57 PM
Highlights/changes the column and row appearance as the cursor mov Need Help with excel Excel Discussion (Misc queries) 2 July 8th 08 10:20 PM
can I have the cursor go to same row/column in each sheet Turbo Excel Discussion (Misc queries) 4 May 29th 08 02:25 PM
how to move the cursor to column A after entering data column F tskaiser New Users to Excel 2 April 29th 06 02:28 PM
Why is my tab key moving my cursor from column A to column k? eterp05 Excel Discussion (Misc queries) 2 October 14th 05 07:17 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"