+ Reply to Thread
Results 1 to 11 of 11

Cursor keeps changing - wrong cursor

  1. #1
    Registered User
    Join Date
    12-16-2017
    Location
    Sarasota
    MS-Off Ver
    2011
    Posts
    12

    Cursor keeps changing - wrong cursor

    As I move the cursor around it is usually the white cross. But on some cells I get a cursor with four arrows (Left-right-up-down). When I click on the cell, I get a format picture frame with handles.
    Anybody know how to make that go away?
    I've attached a small vid demoing this.
    Thanks for any help.

  2. #2
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Cursor keeps changing - wrong cursor

    I don't think you want it to go away. the mouse pointer (cursor) with the four arrows indicates you are hovering over a movanle object. If you press and hold the left mouse key when that pointer image appears, you can drag the object to a new location on the sheet. The mouse pointer icons are part of the Windows application and can be set through Control Panel.
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!

  3. #3
    Registered User
    Join Date
    12-16-2017
    Location
    Sarasota
    MS-Off Ver
    2011
    Posts
    12

    Re: Cursor keeps changing - wrong cursor

    JLGWhiz,
    Thanks for trying to help.
    I forgot to mention, this is on a Mac (so no control panel).
    The cell I'm hovering over has a formula in it (a simple sum).
    It is not a movable object (as far as I can tell).
    I can find nothing in the Excel perfs about cursors.
    It's annoying because I can't enter certain cells.
    When I click on the cell, I get the picture format tool box and a rectangle with handles.

    Any other ideas?

    Thanks.

  4. #4
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Cursor keeps changing - wrong cursor

    It would be better if you post the workbook (remove sensitive data)
    To attach workbook, click GoAdvanced \ look below for ManageAttachments \ follow screen instructions.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  5. #5
    Registered User
    Join Date
    12-16-2017
    Location
    Sarasota
    MS-Off Ver
    2011
    Posts
    12

    Re: Cursor keeps changing - wrong cursor

    KEV_

    Thanks for suggestion.

    Copy attached.

    If I hover the cursor over cells B2, B3, C2, C3, D2, D3 I get the unwanted cursor.

    Thanks
    Attached Files Attached Files

  6. #6
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Cursor keeps changing - wrong cursor

    Quote Originally Posted by hnickm2 View Post
    KEV_

    Thanks for suggestion.

    Copy attached.

    If I hover the cursor over cells B2, B3, C2, C3, D2, D3 I get the unwanted cursor.

    Thanks
    You have an empty text box in that area. When the four arrows appear, right click and the nodes for the text box will appear. You can then delete it if desired.

  7. #7
    Registered User
    Join Date
    12-16-2017
    Location
    Sarasota
    MS-Off Ver
    2011
    Posts
    12

    Re: Cursor keeps changing - wrong cursor

    JLGWiz,

    Thanks for your reply.

    I guess I don't know what that is. When I right-click on the cell, the tool bar changes to picture format and I get a rectangle with nine handles. I delete it, but the same thing happens again.
    The cursor never changes. It must be some sort of formatting of the cell, but I don't have a clue.

    Thanks again.

  8. #8
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Cursor keeps changing - wrong cursor

    Why do you have 948 text boxes in that sheet?
    I ran some VBA to list and count them

    TextBoxes.jpg

  9. #9
    Registered User
    Join Date
    12-16-2017
    Location
    Sarasota
    MS-Off Ver
    2011
    Posts
    12

    Re: Cursor keeps changing - wrong cursor

    KEV_

    Thanks for taking the time to help.
    I have no idea. Do you know how to get rid of them?
    It's nothing I did intentionally.
    Thanks again.

  10. #10
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Cursor keeps changing - wrong cursor

    You are welcome
    Please mark the thread as solved (top of thread under ThreadTools)
    If you click AddReputation it acknowledges the help given by author of that post

    Attached is your textbox-free workbook
    - how on earth you ended up with 948 textboxes by accident, we can only guess...

    I ran a simple macro against it
    Please Login or Register  to view this content.
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    12-16-2017
    Location
    Sarasota
    MS-Off Ver
    2011
    Posts
    12

    Re: Cursor keeps changing - wrong cursor

    kev_

    Thanks bunches. I still have no clue what happened, but now it's fixed.
    Thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro to move cursor when cursor is moved to certain column
    By skylark332 in forum Excel General
    Replies: 3
    Last Post: 12-08-2015, 01:03 PM
  2. Replies: 1
    Last Post: 07-22-2015, 03:34 PM
  3. Cursor Highlights the wrong Cells in Excel
    By litzwhip in forum Excel General
    Replies: 1
    Last Post: 03-23-2013, 01:21 PM
  4. Set active cursor in TextBox (blinking cursor)
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2009, 10:54 PM
  5. [SOLVED] why am I getting a 3 d cross cursor instead of a pointer cursor?
    By 3 d cross cursor - turn it off in forum Excel General
    Replies: 1
    Last Post: 04-11-2006, 07:38 PM
  6. Cursor disappears / Cursor verschwindet
    By Cevikel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2006, 12:10 PM
  7. Changing how cursor toggles.
    By LSD in forum Excel General
    Replies: 2
    Last Post: 03-07-2005, 02:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1