Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
DO
 
Posts: n/a
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Form ComboBox question WTG Excel Worksheet Functions 3 February 26th 05 04:27 PM
How can I run a macro in the background whilst a UserForm is visib cdb Excel Discussion (Misc queries) 3 February 10th 05 06:58 PM
UserForm TextBox/ComboBox question grasping@straws Excel Discussion (Misc queries) 1 February 2nd 05 11:14 AM
Vlookup in a userform R D S Excel Discussion (Misc queries) 6 January 26th 05 09:22 PM
Tricky ComboBox / Filter query [email protected] Excel Discussion (Misc queries) 0 December 11th 04 10:37 PM


All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"