To start with .... As I read it you should be refering to the
passed combo box in the procedure setcolor instead of trying to look at
MyComboBox1 all the time. SetColour doesn't know the object MyComboBox1 from
Eve!!

To refer to the combo box then can we assume you are in the combo box


In sub SetColour try refering to cbox.BackColor and so on and see if that
helps.

I copied the method  SetColor incorrectly!

The actual method is:

Private Sub SetColor(cbox As ComboBox)

If cbox.Value = "Please Select" Then
cbox.BackColor = &H80FFFF
Else
cbox.BackColor = &HFFFFFF
End If

End Sub

It just doesn't like the line:

SetColor(MyComboBox1) in the Sub MyComboBox1_Change(). Any clues,
anyone?

> However, this does not work. I get an error that reads: "Run-time
> error '424': Object required."

Don't you want those "MyComboBox1" references to be "cbox" (the object
parameter passed to the subroutine)?

> Also, rather than calling "SetColor(MyComboBox1)", is there a way
> to reference the "current" combo box using a variable similar to
> "this" in Java?

You may be able to use some variation of "Application.Caller"...

pls try this
Private Sub SetColor (cbox As ComboBox)

If cbox.Value = "Please Select" Then
cbox.BackColor = &H80FFFF
Else
cbox.BackColor = &HFFFFFF
End If
End Sub

SetColor(MyComboBox1)

should be

Call SetColor(MyComboBox1)