+ Reply to Thread
Results 1 to 4 of 4

Return focus and escape from cell?

  1. #1
    Forum Contributor JP Romano's Avatar
    Join Date
    10-09-2008
    Location
    Princeton, NJ
    MS-Off Ver
    2010
    Posts
    500

    Return focus and escape from cell?

    Hello all - having a little trouble getting focus back to my Excel window and escaping the current cell after a double click event.

    Basically, when the user double clicks on a cell, the program loads something in another application... but I can't seem to get the focus back to Excel.

    When I click on the window manually, I can see the cursor actively blinking in the cell that was double clicked upon.

    Anybody know the easiest way to get around this (other than making my cells uneditable)?

    Thanks
    Last edited by JP Romano; 02-23-2011 at 11:32 AM. Reason: Solved

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Return focus and escape from cell?

    Hi JP Romanodouble
    what the click event code?
    you may have to diable events?
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Return focus and escape from cell?

    The double-click event provides a cancel argument. Set that to true to avoid entering edit mode.
    Remember what the dormouse said
    Feed your head

  4. #4
    Forum Contributor JP Romano's Avatar
    Join Date
    10-09-2008
    Location
    Princeton, NJ
    MS-Off Ver
    2010
    Posts
    500

    Re: Return focus and escape from cell?

    Sorry for the delay - thanks Romperstomper...that did the trick!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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