I need a little help, if you copy the code below into word:

Dim muppet
Dim I As Integer

Private Sub UserForm_Initialize()
For I = 0 To 30
For Each muppet In Controls
    If TypeOf muppet Is ComboBox Then
    muppet.AddItem I
    muppet.Text = 0
    End If
    Next muppet
Next I

End Sub

Oh and have a two comboboxes on the form.  Basically I am trying to write
some code which will change both the comboxes, if the number is 0 background
will be white, if it is anything else it will be red.

I know I can use the change event for each combobox, but I would like to do
it for the collection.  Is this possible? :p

TIA

Mark

Your message has been{*filter*} here for a while with no responses. Perhaps no
one can quite figure out what you're trying to do. Could you take another
stab at describing your needs?

Bill Coan