+ Reply to Thread
Results 1 to 3 of 3

ActiveX combobox dropdown list not displayed when used in multiple columns

  1. #1
    Forum Contributor
    Join Date
    01-08-2017
    Location
    Salt Lake City, Ut.
    MS-Off Ver
    2019 and 365
    Posts
    135

    Question ActiveX combobox dropdown list not displayed when used in multiple columns

    Keeping with forum rules, I have created a new tread since I already marked the previous one related to this topic as RESOLVED.

    Akuini had given me code that helped to resolve issues I had using activeX combo boxes, but I modified the code to more directly reflect how I want to use this in my workbook.

    In the code originally showed in the previous ticket when a column is selected the combobox is automatically displayed and also automatically displays the dropdown list. This allows the user two choices, they can either just scroll or down arrow through the dropdown list or they can begin typing a search string that will sort and reduce the list to show the desired results to select.

    This works great when lets say there are two columns using the combobox that are separated by another column that is basically blank or does not use a combobox. However when I place multiple columns together that utilize the combobox as shown in the modified code I have attached, the first column automatically shows the dropdown list when a cell in the column is selected, and once the choice is made and the user hits Enter, then the selected entry is entered into the column and the target or cursor is then moved to the next column.

    I have three columns side by side that utilize the combobox with dropdown list. In the attached code the first column works fine with the combobox, automatically displaying the dropdown list, however once that choice has been completed and the target then moves to the next cell in the next column, the combobox appears, but fails to automatically show the dropdown list. If I type in characters to reduce the selection, then you must click on the dropdown arrow to display the dropdown list where you can make a selection. This same issue continues into the next column where once again I use the combobox to make a selection.

    Note: In the first two columns the user MUST select and entry in the list used to populate the dropdown list. However in the third column I modified the code to allow the user to either choose from the list or to make an entry NOT in the list. This entry is not automatically added to the list and I do not want it added.

    I hope I have not bastardized the original code too much. Any help is greatly appreciated. I have tried multiple solutions, but so far have been unsuccessful.

    Thanks in advance.

  2. #2
    Forum Contributor
    Join Date
    01-08-2017
    Location
    Salt Lake City, Ut.
    MS-Off Ver
    2019 and 365
    Posts
    135

    Re: ActiveX combobox dropdown list not displayed when used in multiple columns

    Well, Just after making this post, I seem to have found the Simple solution. I simply added the line "Application.Sendkeys "%{DOWN}"" to the sub called "toShowCombobox"

    See the modified attached file.

  3. #3
    Valued Forum Contributor
    Join Date
    02-02-2016
    Location
    Indonesia
    MS-Off Ver
    Office 365
    Posts
    997

    Re: ActiveX combobox dropdown list not displayed when used in multiple columns

    I simply added the line "Application.Sendkeys "%{DOWN}"" to the sub called "toShowCombobox"
    That's a good idea.

    The automatically hide-unhide combobox is indeed a bit uncomfortable to use, especially when the it's applied to multiple columns where they are next to each other. Another way to try is to make the combobox appears only when certain action is executed, such as double-click the cell or pressing a keyboard shortcut (let's say alt+right arrow).


    I hope I have not bastardized the original code too much.
    It looks like you understand the code well, so feel free to amend it as needed.

+ 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] Dependent DropDown lists in VBA /=INDIRECT() on ActiveX ComboBox/
    By bongo_bg in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-25-2018, 02:03 AM
  3. ActiveX ComboBox DropDown
    By EssoExplJoe in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-24-2017, 09:21 AM
  4. How to create a ActiveX dropdown list
    By QuantEdge in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-18-2017, 06:47 PM
  5. ActiveX Combobox dropdown 'reset' when repopulating
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-27-2017, 06:01 AM
  6. ActiveX Combobox with multiple columns and "linking" a cell
    By Jelmer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-30-2016, 02:00 PM
  7. ActiveX Combo Boxes - can I define the list to be displayed via formula?
    By pci1239 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2012, 06:59 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