hi,
i'm using the mousedown event on a an Office Excel 2003 user form combobox,
to trigger ADO calls to Access to populate the dropdown. I also clear out the
combobox each time, so the list doesn't duplicate each time it's clicked.
However, if mouse released (up), then selects an item and clicks (down), the
selected item does not show in combobox - it's always the 1st item in list
that shows.
If I do not release mouse (up), and select from list, it works fine. It's
like the mousedown event executes again when i select the item.
any idea as to how I could handle this? i'm pretty new to working with
mousedown/up events.
thanks!
Don
Bookmarks