Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
View Code for pointer?
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. -- Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
View Code for pointer?
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. -- Rick (MVP - Excel) "Doug" wrote in message ... 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. -- Thank you! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
View Code for pointer?
You could draw a vertical line (insert line shape), then drag it over
the chart area Doug wrote: 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
View Code for pointer?
-- Thank you! "Rob van Gelder" wrote: You could draw a vertical line (insert line shape), then drag it over the chart area Doug wrote: 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
View the code in a add-in | Excel Worksheet Functions | |||
view raw sheet code | Excel Programming | |||
View Code | Excel Programming | |||
Mouse in Code View | Excel Programming | |||
Changing the mouse pointer in code | Excel Programming |