Bugs using combobox 2-fmstyledropdownlist

B

Bart

Hi,
I was wondering if anyone has alot of experience with
using Active X comboboxes with the style set to 2-
fmstyledropdownlist in Excel 97.
Because the more I use it the more thbugs are coming up
and setting the style to 2-fmstyledropdownlist seems
imparative.
For example:
Copy a worksheet with comboboxes throug code resets all
public variables.
Copying a worksheet manually (eg by the user)triggers
combobox change and click events.
SaveAs the workbook by the user (eg menu selection) also
triggers combobox change and click events.
A SaveAs by the user resets the values of some comboboxes.

I'm getting a bit low on inventing workarounds.

If someone is has experience in these particular problems
or could direct me to a site or document please post a
reply and follow the thread because it might get
interesting.

Thanks
Bart
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide button in a combobox dropdown 0
ComboBox match issue 4
XL2003 Userform; cmbbox uses named range source, changes unexpecte 1
ComboBox makes Excel hang 1
How to populate a combobox based on selection from another combobo 6
Linking a ComboBox 0
Why does Calendar Pop-Up when clicking other ComboBox? 7
Identify what Combobox was changed to update the correct item on the previous Form 2

Top