+ Reply to Thread
Results 1 to 3 of 3

ComboBox autotab bug(?!)

Hybrid View

  1. #1
    Registered User
    Join Date
    03-12-2020
    Location
    Setúbal. Portugal
    MS-Off Ver
    2019 Pro CR
    Posts
    3

    ComboBox autotab bug(?!)

    Can someone please explain this behavior?
    I’ve a userform with 2 ComboBoxes. The 1st one is populated from a range of cells which contains 4 digit numbers (cells formatted as text) and has the AutoTab property set to TRUE and MaxLenght set to 4. Both ComboBoxes have TabStop property set to TRUE. When I type in this 1st ComboBox a number, it tabs automatically as expected to the 2nd ComboBox, EXCEPT if the number ends in 0. Why is that so?
    What am I doing wrong?
    Many thanks in advance for your help
    I attached the file with this behavior.
    P.S. My first POST ever.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    01-14-2013
    Location
    Austria
    MS-Off Ver
    2016 / 2019
    Posts
    339

    Re: ComboBox autotab bug(?!)

    I tested it and it works for me (MS Office Professional Plus 2016)
    The Combobox also accepts data which is not in the list and changes after input of 4 characters (chars and digits) focus to the other Combobox

  3. #3
    Registered User
    Join Date
    03-12-2020
    Location
    Setúbal. Portugal
    MS-Off Ver
    2019 Pro CR
    Posts
    3

    Re: ComboBox autotab bug(?!)

    Thank you so much for your reply gue2013.
    In my case the ComboBox also accepts data which is not in the list, including for instance, 1910, jumping for the next ComboBox after the 4th digit. However, if the data is in the list and ends with a 0, example:1530 it doesn’t jump. This happens in the following Excel versions:
    Office265Pro 16.0.11929.20436 32bit
    2019Pro 16.0.12527.20260 32bit
    After you answer, I managed to try it in Excel2010 14.0.7237.5000 32bit and it’s working perfectly. So, I guess it’s a problem related to Excel version not the code himself

+ 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] ActiveX Combobox in worksheet when populating the list based on another Combobox get error
    By jprlimey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-27-2020, 10:54 AM
  2. [SOLVED] ComboBox to populate Listbox and 2nd Combobox based on 1st combobox dropdown choice
    By bbqqsmokeman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2017, 08:21 PM
  3. [SOLVED] Code required to Auto Populate 3rd Combobox based on 02nd Combobox Selection
    By bimmy80 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-14-2015, 03:56 AM
  4. Userform Combobox to populate form: Can I change the order of the columns in the combobox?
    By CraigWiggins in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2014, 12:14 PM
  5. autotab doesnt work on userform first open
    By ramzter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-06-2014, 08:07 PM
  6. [SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 04:50 PM
  7. Autotab does not always work
    By Pierre Scerri in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-06-2006, 01:55 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