Is there any option to highlight the whole row when a cell is selected? That means when i move from one cell to another, I expect the whole row that contains the second cell to be highlighted. It would be very helpful for me to work on sheets with larger number of columns.
Right click on your sheet and select View-> Code. Enter this code in there -Now save your file and come back to the sheet. Whichever cell you click on, the row will be highlighted.
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
That code will highlight the whole row because it is selected. Not a good option if you actually want to work with the cell tht was originally selected
Worksheet event code is stored on a worksheet module. To add it to your worksheet, do the following:Please Login or Register to view this content.
Copy the code
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste
Last edited by royUK; 01-14-2012 at 02:49 PM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks