Can the default Cursor in 2016 be change back to an Arrow?

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
125
I can't seem to find anywhere how to change the Plus or Cross sign (pointer, cursor) back to just a plain ol Arrow.
Does anyone here know if it can be done. I want to make my pointer stay as a default Arrow instead of a cross when I'm working on my spreadsheets.

Thanks in advance if you come up with this answer!

Regards,
U.S. :cool:
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
125
Last edited:

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,974
Office Version
2013
Platform
Windows
I think it can only be enforced by VBA
Try this for the Nw arrow

Code:
Sub ChangeCursor()
  Application.Cursor = xlNorthwestArrow
 End Sub
Otherwise it needs to be done via control panel and that will affect ALL applications
 

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
125
I think it can only be enforced by VBA
Try this for the Nw arrow

Code:
Sub ChangeCursor()
  Application.Cursor = xlNorthwestArrow
 End Sub
Otherwise it needs to be done via control panel and that will affect ALL applications
Thank You but that does not work for me as well. You would think they would make this a simple option to do. It can't be that hard can it? It must be cuz I can't find the answer anywhere. All I wanna do is just have an arrow cursor as a default!!!
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,974
Office Version
2013
Platform
Windows
you have tried changing it in the Control Panel, haven't you ??
Control Panel>>Mouse>>Pointer tab>>change to suit.

Obviously it is (that hard) !!
Do you have the Developer tab on you Excel 2016 ?
If so select that tab>>Click on Visual Basic>>Dbl click "This workbook" in the LH window
Paste the code I provided in the RH pane where the cursor is flashung>>In the toolbar press the "run" arrow
Cursor should now be NW arrow
 
Last edited:

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
125
Thanks Mike ...

I always have my NW arrow except when I'm in Excel. I tried what you said and I just can't seem to make it work.
Your help has been much appreciated!
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
18,974
Office Version
2013
Platform
Windows
OK....the obvious eluded me !!!
File >> Options>> Advanved>>Editing options>> Check the box that says "Enable fill handle and cell drag and drop"
If that don't work....I'm off to the bar !!!
 

Ultimate Selector

Board Regular
Joined
Dec 15, 2013
Messages
125
OK....the obvious eluded me !!!
File >> Options>> Advanved>>Editing options>> Check the box that says "Enable fill handle and cell drag and drop"
If that don't work....I'm off to the bar !!!
I did that plus it was checked already anyways. But again Thanks!

Hey have one .. no, no make it two for me while yur at it! Heh-Heh :cool:
 

Watch MrExcel Video

Forum statistics

Threads
1,102,711
Messages
5,488,450
Members
407,638
Latest member
brandynl

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top