Boxes on UserForm

[Rocky0201]

Hi everyone...

I have a userform with several ComboBoxes, TextBoxes and ListBoxes.

If I select criteria from say ComboBox1, lookup the value selected and wish to populate another ComboBox (say ComboBox2) with data found, How could I prevent the ComboBox2_Click event from executing?

In my ComboBox1 event, If I do;

ComboBox2.value = "Item Found:

The code in ComboBox2 runs where I only want to display the value.

I will, however, need to have the ability to select ComboBox2 and select criteraia from this box and populate another ComboBox, TextBox or ListBox.

Any help would be great...

Thanks

 

[Andrew Poulsom]

I like Chip Pearson's method of suppressing UserForm events:

http://www.cpearson.com/Excel/SuppressChangeInForms.htm

 

[Rocky0201]

Thanks Andrew...

I tried using the example from the link you provided.

I get a complie error: Method or data member not found on the statement; Me.EnableEvents = True in the UserForm_Initialize routine.

My Public EnableEvents as Boolean is defined in Module2 where all of my other public definitions are kept.

Any thoughts?

Thanks again...

 

[Andrew Poulsom]

You need to declare the variable EnableEvents in the UserForm module (as it is in the link I posted).

 

[Rocky0201]

By golly I think it's going to work...

Thanks so much Andrew...