ComboBox caniptions!

[pdbowling]

Hey all,
I've got a form with a couple of comboboxes on it.

In ComboBox_change() I call a function to do processing depending on the choice from the comboBox.

The problem is, it autoruns when the workbook is opened and calls the function with an empty parameter because it hasn't been manually specified yet. Is there a way to have it skip the autorun stuff? More design info:::::

The combobox.add item
methods are in the thisWorkbook section of the Project so I'm wondering if this is what is spawning the "OnChange()" event for the combobox.
Thanks everyone.
PB

 

[crosmill]

You can set an If condition for it

If variable = NULL Then
Else
....your code here
End If