Results 1 to 12 of 12

Sheet-related processing causes Excel VBA Userform to stop processing Tab/Enter

Threaded View

Joaquin M Lopez Muno Sheet-related processing... 03-22-2014, 04:53 AM
Winon Re: Sheet-related processing... 03-22-2014, 09:06 AM
Joaquin M Lopez Muno Re: Sheet-related processing... 03-22-2014, 09:21 AM
Winon Re: Sheet-related processing... 03-22-2014, 09:52 AM
Joaquin M Lopez Muno Re: Sheet-related processing... 03-22-2014, 10:59 AM
Norie Re: Sheet-related processing... 03-22-2014, 09:57 AM
Joaquin M Lopez Muno Re: Sheet-related processing... 03-22-2014, 11:04 AM
Winon Re: Sheet-related processing... 03-22-2014, 12:08 PM
Joaquin M Lopez Muno Re: Sheet-related processing... 03-22-2014, 12:38 PM
Winon Re: Sheet-related processing... 03-22-2014, 01:04 PM
Joaquin M Lopez Muno Re: Sheet-related processing... 03-22-2014, 01:32 PM
Norie Re: Sheet-related processing... 03-22-2014, 03:02 PM
  1. #1
    Registered User
    Join Date
    03-22-2014
    Location
    Spain
    MS-Off Ver
    Excel 2010
    Posts
    6

    Sheet-related processing causes Excel VBA Userform to stop processing Tab/Enter

    This is a distilled form of a problem I'm having with a real application. Under certain circumstances, the initialization/activation code of a userform might result in the form losing its ability to correctly process tabs and enters: rather than switching between controls, these keys are passed to the controls themselves (even if they have TabKeyBehavior set to False). The simplest way I've found to systematically reproduce the problem is by having this at activation time:

    Private Sub Userform_Activate()
    Application.DisplayDocumentInformationPanel = True
    End Sub
    which seemingly causes Excel to "half-steal" the focus from the userform, so to say: the userform remains focused but tab/enter processing fails. The problem immediately goes away by switching to some external app and getting back to Excel (pressing ALT+TAB twice, for instance.)

    Steps to reproduce the problem:

    Download tabnotworking.xlsm.
    Open tabnotworking.xslm.
    Enable macros.
    Click on the "Launch UserForm1" button.
    UserForm1 is displayed and the textboxes accept input from the user, but tab/enter does not work as expected.
    Press ALT+TAB twice or click on some external app and get back to the form: now tab processing works OK.
    Once tab/enter processing has been restored, further usage of the form, including relaunching it, seems to work OK (most of the time). To reliably reproduce the problem again, close the book and start from step 2.


    There are numerous references on the Internet to problems with tab processing seemingly related to this one, but no actual solution. Any clue on what's happening and how it could be solved? Thank you,
    Last edited by Joaquin M Lopez Muno; 03-22-2014 at 09:18 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Very large sheet not processing at once.
    By comp in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-24-2014, 10:44 PM
  2. Reduce processing time for processing multiple excel sheets
    By rexer231 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2014, 09:25 AM
  3. Replies: 17
    Last Post: 01-10-2011, 10:40 PM
  4. User Input / Processing Sheet
    By jeremymc7 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-23-2008, 02:32 AM
  5. [SOLVED] Processing code on wrong sheet
    By Jeff Klein in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2005, 03:06 PM

Tags for this Thread

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