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

Ultimate Selector

Board Regular
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:
 

Ultimate Selector

Board Regular
Last edited:

Michael M

Well-known Member
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
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
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
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
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
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:
 

Some videos you may like

This Week's Hot Topics

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
Top