ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Getting combobox dropdowns to appear on a userform when tabbed to. (https://www.excelbanter.com/excel-discussion-misc-queries/15664-getting-combobox-dropdowns-appear-userform-when-tabbed.html)

DO

Getting combobox dropdowns to appear on a userform when tabbed to.
 
I have generated a userform with several comboboxes. A person using the form
tabs through the comboboxes and makes appropriate changes to the values. I
want the dropdown selection to appear when the combobox is tabbed to. I used
the Enter event for each combobox to execute the dropdown. However, when I
tab through the comboboxes without making any changes, the dropdown menus
only appear on every other combobox. If I make a change to a combobox and
tab to the next one, its dropdown menu will appear. I want the dropdown
menus to appear for all of the comboboxes when they are tabbed to regardless
of whether or not any changes to previous comboboxes are made.
Thanks,
DO


All times are GMT +1. The time now is 03:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com