hi all, this is my first post, im quite a noob let it be said!

i have a frame, in the frame i have a dropdown box with 3 options...

Open, Pending and Closed, and as you can see im trying to make the fram background color change for whichever option on the dropdown is selected.

Its giving me a huge headache at this stage and im sure one of you wise ones can point me in the right direction, thanks!!

Private Sub ComStatus_Change()
If ComStatus.Text = "Open" Then
FrmStatus.BackColor = blue
ElseIf ComStatus.Text = "Pending" Then
FrmStatus.BackColor = red
ElseIf ComStatus.Text = "Closed" Then
FrmStatus.BackColor = green
End If
End Sub