Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 469
  • Last Modified:

Activex Combobox in Excel

I have a combobox that loads and populates when a workbook loads. Currently, when I click the dropdown arrow and select an item in the list a message box pops up and diplays the selected item. So far so good. However the dropdown stays in a dropped down state and you are able to select another item in the list, before clearing the messagebox. Is that normal behavior or am I missing something-- which is very likely.
0
trekrok
Asked:
trekrok
1 Solution
 
Saurabh Singh TeotiaCommented:
Trekrok,
To check whats wrong...need to see your file..post that will be able to comment over this...
Saurabh...
0
 
Wayne Taylor (webtubbs)Commented:
Yes, it does seem to be normal behavior. To "disable" this behavior, select something else, possibly the cell underneath the Combobox....

    Private Sub ComboBox1_Change()
        [A1].Select
        MsgBox ComboBox1.Text
    End Sub

I'm curios though - why do you need to show the selected item in a MsgBox?

Wayne
0
 
trekrokAuthor Commented:
Thanks. The MsgBox was just to help me figure out how this thing was working.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now