View Code for pointer?

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

Is their a view code that i can use to make the pointer show a line down the
screen? this would be very helpful when viewing chart data.
 
Maybe you can make use of this... right click the tab at the bottom of the worksheet that you want this functionality on, select View Code from the popup menu that appears and then copy/paste the following into the code window that opened up...

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Union(Target.EntireColumn, Target.EntireRow).Select
Target.Activate
End Sub

Now, go back to the worksheet and double click any cell and both its row and column will become highlighted. The only downside to this method is if you have "Move Selection after Enter" enabled... hitting the Enter key will still move the selection, but not the highlight... you need to do a regular mouse click anywhere on the grid to remove the highlight or simply double click another cell to move the highlight to it.
 
You could draw a vertical line (insert line shape), then drag it over
the chart area
 
Back
Top