Consulting

Results 1 to 5 of 5

Thread: Mouse Icon over Cell Change

  1. #1
    VBAX Expert
    Joined
    Apr 2007
    Location
    Orlando, FL
    Posts
    751
    Location

    Mouse Icon over Cell Change

    Hi I have a Range of C2:C200 that I have a BeforeDoubleClick Script. When double clicked in cell It loads up a form with data. The only thing is these cells look normally like every other cell so the user won't know if double clicked it will bring up the form for editing. Is it Possible to say Range C2:C200 Or All C:C to have the "Pointing Finger Cursor" Is that possible.

  2. #2
    Moderator VBAX Master geekgirlau's Avatar
    Joined
    Aug 2004
    Location
    Melbourne, Australia
    Posts
    1,464
    Location
    AFAIK you can't do any "mouse movement" events within Excel - it only works when you actually select a cell.

    Of course the obvious question is, why do they look the same? Why not distinguish that range of cells visibly in some way?

    You can also use Data Validation to display a message - just set the input message to whatever you want to display, however this also works when you select the cell, not when the mouse moves over it.

  3. #3
    VBAX Master
    Joined
    Jul 2006
    Location
    Belgium
    Posts
    1,286
    Location
    Why not using a comment ? "Doubleclick here to see form ..." I believe there exists even a kb-article about showing the comment of a cell at a certain position (pe. A2). So every comment, when you hover over the cell, is displayed at that position.

    Charlize

  4. #4
    VBAX Contributor Ivan F Moala's Avatar
    Joined
    May 2004
    Location
    Auckland New Zealand
    Posts
    185
    Location
    you CAN DO this, however as the above have indicated, why not just comment or highlight the range that this effects.
    Kind Regards,
    Ivan F Moala From the City of Sails

  5. #5
    VBAX Expert
    Joined
    Apr 2007
    Location
    Orlando, FL
    Posts
    751
    Location
    If Possible how can I make this happen. Otherwise I will go with the Highlight option.

Posting Permissions

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