Free Microsoft Excel 2013 Quick Reference

Excel Mouse Cursors

Where can I get a list of all the mouse cursors, such as Autofill, Move, Copy?


In Excel the gridlines clutter up the look of the screen. But they are very
useful in knowing where to click to make changes and select cells. I would
like to have the gridlines be invisible except in a floating area around the
mouse cursor.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

I have been learning to manipulate shapes in VBA and have come across a problem that I can't quite crack. I am attempting to have a worksheet shape autocenter itself on my mouse pointer as I move the mouse. It nearly works, but the shape does not quite land on the mouse cursor as it should - it is offset down and to the right.

I know that the problem lies within the difference between the values returned for the mouse position (the entire Excel Window) versus the position returned for the shape object (the worksheet Window) [Due to the toolbars and row 'header'] but I just can't seem to find a proper solution for determining the proper 'offset' factor.

Can someone point me in the right direction?

I've attached the code I have so far below:

Code:
Sub MouseMoveObjectTest()
Dim lngCurPos As POINTAPI
For Each sp In Worksheets("Sheet1").Shapes
sp.Delete
Next
 
Set a = Worksheets("Sheet1").Shapes.AddShape(92, 50, 50, 20, 20)
a.Name = "Oval2"
a.Fill.ForeColor.SchemeColor = False
Do
 
GetCursorPos lngCurPos
 
' Find the Center of the Stationary and Moving Object
CenterRowStationary = lngCurPos.Y
CenterColStationary = lngCurPos.x
CenterRowMoving = Shapes("Oval2").Top + Shapes("Oval2").Height / 2
CenterColMoving = Shapes("Oval2").Left + Shapes("Oval2").Width / 2
 
MovementSpeed = 1.25
' Now comes the hard part.  I want the object to follow a straight path to the stationary
' object, so I will need to use Right Triangle Math to do this.
' First, I need to determine the Hypotenus of the Right Triangle give the height and width
' of the right triangle
TriangleHeight = Abs(CenterRowStationary - CenterRowMoving)
TriangleWidth = Abs(CenterColStationary - CenterColMoving)
TriangleHyp = Sqr(TriangleHeight ^ 2 + TriangleWidth ^ 2)
' Ok, now I will need to use the movement speed (which is the hypotenuse of a smaller
' right triangle within the larger right triangle above) to determine the height and width
' of this new triangle.  These values are directly proportional to the values in the above
' triangle.
If TriangleHeight = 0 Then
NewTriangleHeight = 0
Else
NewTriangleHeight = (TriangleHeight / TriangleHyp) * MovementSpeed
End If
If TriangleWidth = 0 Then
NewTriangleWidth = 0
Else
NewTriangleWidth = (TriangleWidth / TriangleHyp) * MovementSpeed
End If
' These new values are the row and column adjustment factors we will use to move
' the object.
 
With Shapes("Oval2")
If (.Top + Shapes("Oval2").Height / 2) > CenterRowStationary Then .Top = .Top - NewTriangleHeight
If (.Top + Shapes("Oval2").Height / 2) < CenterRowStationary Then .Top = .Top + NewTriangleHeight
If (.Left + Shapes("Oval2").Width / 2) > CenterColStationary Then .Left = .Left - NewTriangleWidth
If (.Left + Shapes("Oval2").Width / 2) < CenterColStationary Then .Left = .Left + NewTriangleWidth
End With
DoEvents
Loop
End Sub
Thanks.

Owen

Hello everybody!
I would like to change the mouse cursor when the pointer passes over (without clicking) some cells which have double-click-event script attached.
I know how to change the cursor with a custom one. The pb is for me to identifie that the pointer is over the cell so as to launch the cursor change macro (and reverse when going over another cell).
Excel does that, for ex, with commented cells but can VBA do it also??
Any tips?
Thanks
Th

Hello,

I have been having an issue with one of the employee's excel programs in my office. We are running the 2007 edition. When opening a document in excel the cursor completely disappears. It still has full functionality (if you can figure out where it is).

One odd thing I just noticed is if you have excel open, then open up my documents, the cursor is no longer visible there either. However when excel isn't open the cursor is visible.

I have searched for an answer to this problem, however I have not been able to find one.

I have tried opening excel in safe mode, updating video drivers, and turned down the hardware acceleration on the chipset.

Any opinions would be extremely helpful, I will be checking frequently and trying to resolve this issue quickly because it is making the employee's work impossible.

Thanks,

Peter.

Hello, Im setting up some buttons that open a UserForm, is there any way of making it open them next to the mouse cursor?

Thanks

Does anyone know how to remove or hide the mouse cursor entirely when a specific worksheet is activated?

thanks for any help

Hi everyone,

I would like to change A1 cell's Interior.ColorIndex to red color and A1's font format to Italic, while mouse cursor on top of A1 cell.

Can i do it with a VBA code or any different way to do it?

Thanks a lot.

For a funny example:

Code:
Sub CursorOnA1() 
    If MouseCursor OnTopOf [A1] Then 
        With [A1] 
            .Interior.ColorIndex = 3 
            .Font.Italic = True 
        End If 
    End If 
End Sub


Is any code how to move mouse cursor possition to some possition?
Thank you.

How do I stop the input cell from jumping to the mouse cursor?

I am trying to find the method required to change the mouse cursor from a
hand shape to a pointer, for a check box which was created as a shape. Can
someone please help?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200607/1

Using office 2003 is it possible to copy, paste and print a screen with the
mouse cursor showing? If not where can I get copies of all mouse cursor
shapes to use in pupil instruction manuals?


currently, the sheet have two buttons.
i press one button. then,,,

i want to move the mouse cursor the other button.

*** Sent via Developersdex http://www.developersdex.com ***

If I open an Excel 2003 x-y scatter line chart with multiple (x,y) line
graphs (or open a graph that was saved under Excel 2007), and I move the
mouse over the various lines (some of them may be close to each other) then
there is an x 'offset' in the location of the mouse and when Excel recognizes
a line graph and displayes the line title with a little message underneath
the mouse cursor. Another way to explain thsi behaviour is if you try to
click at a particular line graph, it may not select it, it may select a
different line graph that is located left to where the mouse is.

This is very agonzing when trying to analyze data, which I and my collegues
need to do. Excel 2007 is therefore almost useless to us. Also if you, e.g.,
try to change the color or appearance of the line, you may not be able to
select it easily.

It is as if the internal coordinates of the chart area are not tracked
properly to the mouse coordinates when the mouse moves over the chart area.
Possibly both the x and y coordinates have an 'offset'.

I have update to the service pack 2. Are there further Excel-only updates
available?

I use Excel 2002, under Windows 2000.

PROBLEM: whenever I open Excel, the cursor is immediately "stuck": the "plus" symbol is activated, as if I were holding down the mouse button and selecting blocks of text. I cannot release this: where ever I move the cursor, huge blocks of text are selected, even when I take the cursor off the spreadsheet. The only way I can get out is to use Windows Task Manager and end Excel.

I have Norton Antivirus 2003, with all updates, and have scanned multiple times for viruses, and seem to have a clean system.

Help please: kbeck@ucla.edu

When the excel cursor has hovered over a cell for a short period it should
become visible but transparent so that numbers underneath can be seen without
needing to move the mouse. This is often a problem because you tend to click
on a cell, leaving the cursor there, then when you look up to check the
contents of the cell you can't see them because the cursor is sitting over
the top, so you then need to move the mouse to see the contents.

The cursor could become opaque again once moved.

Hi all
I wish to write my own digitizing program where I paste a scanned graph into an Excel worksheet and then use mouse events like Mousmove and Mousedown get the coordinates of any point on the scanned image.

Please can somebody supply a simple example in VBA showing me how obtain the coordinates of the mouse cursor.

I refer to the following MSDN web page http://msdn.microsoft.com/library/de...tMouseMove.asp

Many Thanks
Tigga

Hi nd many thanks in advance!!

I have a CommandButton and a macro attached to his command.
when I press the command the macro starts runing.
*
*
*
But how can I put my mouse cursor, I mean my mouse pointer somewhere, "say nowhere, say on range("A1")

I can put my selection on:
range("A1") using HTML Code:

I can avoid at the same time 

	HTML Code:
	

if I need to keep my selection always on Range("A1").

But what happen with the mouse pointer.
My CommandButton is on range("D4") and once pressed my mouse pointer is still over the command button.
Disturbing my spreadsheet view.

ANY IDEA, from VBA

Hello. I would like to create an excel spreadsheet with several highlight-able buttons within certain cells. What I would like to do with these buttons is the following: When a user highlights one of these buttons with the mouse cursor, a macro will run and display a set of results to the user; these results will continue to be displayed so long as the user continues to hold the mouse cursor over that button (the results in this case would be a graph of data relative to the location of the highlighted button). When the user moves the cursor off of that button, the data previously displayed will disappear until the user highlights that button again. I can write the graphing macro myself, but I need help with the button-highlighting run-macro functionality described above. Does anyone know how to do this? Any help would be greatly appreciated - thank you.

I track my 401K with an excel spreadsheet that contains the date and price of five funds. I chart the funds percent change by date on a line chart with the category axis set to time-scale. I’ve noticed on charts that are “sized with window” hovering the mouse cursor over data points on the left or center displays the data value as expected, but near the right side of the chart the value of the data is not displayed when the cursor is hovered over a data point. After a lot of troubleshooting, I discovered that if I uncheck the “sized with window” view, I can hover over any point and obtain the data value. Is this a “feature” of the “sized with window” or something I’ve missed in setting up the chart? XY charts do not seem to exhibit this “feature”.

When I go into excel - doesn't matter whether new or saved document, if I move the mouse cursor the cells all highlight blue, I can't type anything. Someone recommended that it may be a 3 button mouse where the middle button is being pressed - but the mouse is a standard two button mouse.

Hope you can help - I am desperate

Thanx in advance

When I am using Excel and want to select a single cell with my mouse, I click
on the cell but I get multiple cells instead. Of course I can still use the
keyboard to change its size, but that takes too long.

Using MS Excel 2003. Highlighted cell for editing is moving on it own to the
cell where ever the mouse cursor is located. Is this normal?

Using Excel, saving in latest Office version (in 2008) and saving in old
formats, how do I enter information in a cell which can be shown by waving
the mouse cursor over it? I would want the cell contents to be either
printable or not printed by applying a small number of keystrokes which could
be explained easily to other users.

Excel 2003: I have found this problem with an embedded chart into
which I copy a map. I then use the Chart Events to track the mouse
cursor and 'drop' waypoints onto the map (making this work is another
topic on it's own!). However, if the chart is wider than the screen
window then as it is scrolled left a point is reached where these
Autoshapes disappear. By trial and error, I have found that they can
be made to re-appear by first selecting a sheet cell then selecting
the chart following every scroll. The problem seems to be linked to
the 'original' RHS boundary of the Window, and any shapes right of
this line will disappear as the window scrolls left. I have also found
that the Chart ToolTips (the tags that say Chart Area or Plot Area
etc. also vanish at around this point.

The problem is repeatable in that it happens on different PCs under
different OS (even in Excel for Mac under OS X). If you want to try
it, then open a Workbook and put a chart on the sheet (any chart with
any data or even no data at all will do). Now select the chart and
draw some shapes on it and evenly distribute them across the chart.
Make sure that you have at least one on the far RHS. To make sure that
the shapes are on the Chart and not the Sheet, grab them and try and
drag them off the Chart - if they are correctly placed you will not be
able to move them past the Chart edges. Now grab the chart RHS handle
and drag it until it is wider than the Window. Use the scrollbars to
move around and you will see that some shapes on the RH side of the
chart are gone. Exactly which ones depends on the width of your Chart
and Window. To see them again, click in a cell and then select the
Chart. Scroll again and it's gone. Repeat until bored.

An extensive search of archive Forums shows that this effect has been
seen by others, as far back as xL97. However, the answers show that
the readers have almost always misunderstood the problem. The most
frequent responses are to a) ensure the Autoshapes are on the Chart
not the Sheet, and b) to group all the shapes. Neither of these will
work, nor will any attempts to change the drawing Order.

I can offer a solution. It's not a real solution derived from
understanding the problem, but more of an engineers work-around (and I
am an Engineer, though in aerospace not software). The approach I have
adopted is to try and scroll using a procedure or event into which
code can be embedded to emulate manually re-selecting the sheet and
chart.

Having tried several methods involving the cursor that all failed, the
one I have made work uses the OnKey procedure. API calls could
probably be used too, but I want this code to run on both a PC and a
Mac.

The code below only deals with a Left scroll but you can probably
figure out how to do Right, Up and Down.

In the Worksheet module as a Worksheet Activate event

'activate the Application Object Window - must be first
else scrollbars will not clear every time
Windows(ActiveWorkbook.Name).Activate
'hide the cursor scrollbars
ActiveWindow.DisplayVerticalScrollBar = False
ActiveWindow.DisplayHorizontalScrollBar = False
're-define the left arrow key to cause a small scroll
Application.OnKey "{LEFT}", "LeftShift" LeftShift code in
a Module
'activate the chart ready for use or bypass step if no
chart on sheet
On Error Resume Next
ActiveSheet.ChartObjects(1).Activate

In the Worksheet module as a Worksheet Deactivate event

'activate the Application Object Window
Windows(ActiveWorkbook.Name).Activate
'put back the cursor scrollbars
ActiveWindow.DisplayVerticalScrollBar = True
ActiveWindow.DisplayHorizontalScrollBar = True
'put the left arrow key back as it was
Application.OnKey "{LEFT}"

Then in a module as a Procedure

Sub LeftShift()

'inhibit screen updating (does not make much difference)
Application.ScreenUpdating = False
'set Application Window active before scrolling
Windows(ActiveWorkbook.Name).Activate
'move stuff left by a little
ActiveWindow.SmallScroll ToRight:=-1
'activate first chart (one chart per sheet expected) ignore
if no chart found on sheet
On Error Resume Next
ActiveSheet.ChartObjects(1).Activate
'reactivate screen updating
Application.ScreenUpdating = True

End Sub

When you select this Sheet only, the action of the arrow key will
change. It will now cause scrolling and the required calls to ensure
that the Shapes are still visible after the scroll. As a clue, it will
get rid of the normal scrollbars so the key is the only way to scroll.
When you select another Sheet, all these changes are put back so that
the scrollbars re-appear and the arrow key behaves normally again.

Limitation: After scrolling, it is always Chart1 on the sheet that is
left activated.

Tip: Use OnKey for ALT+Left to call a procedure that moves 10 or more
cells at a time for faster scrolling emulating a Page Left.
Tip: .For uniform scrolling, set the underlying cells in the sheet to
be small and square. If you are not using the worksheet cells for
data, then the following code added to the WorkSheet Activate code
will do it: The Chart has to be unlocked from the cells first if it is
not to be distorted by this action.

Dim RowNo As Integer, ColNo As Integer
'If there is a Chart 1 then unlock it from cells
On Error Resume Next
ActiveSheet.ChartObjects(1).Placement = xlFreeFloating
'disable screen updating so that it happens faster and
without screen flicker
Application.ScreenUpdating = False
'fix the rows and columns to be equal size
For RowNo = 1 To 255 'max 65538 but 255 is Ok for an
A3 portrait chart
Rows(RowNo).RowHeight = 7.5 'ht in points
Next RowNo
'Columns are in character width, smallest unit =1 is approx
7.5 points
For ColNo = 1 To 255 'max 255 which is Ok for an A3
Landscape chart
Columns(ColNo).ColumnWidth = 1
Next ColNo
Application.ScreenUpdating = True

If anyone can provide a better fix for this problem I would be glad to
use it to replace my efforts.

V8R