Running Macro based on selection from Combo Box

[mtampa]

Hi all,

I have a combo box on a form which has 4 selections. When selection 3 is chosen and the number 3 outputs to it's linked cell, I want a macro to trigger. I have been able to build my macro and it functions correctly when I run it manually, but I cannot get it to fire when the selection is made off the combo box.

However, I am able to simply type the number 3 in the box and hit enter and the macro will run perfectly.

When the form is opened, the combo box selection defaults to choice 1. The VBA I am using is below:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = "$K$3" Then
Select Case Target.Value
Case Is = 3: Call EMPVILL
Case Else: 'Do Nothing
End Select
End If
End Sub

I was hoping someone could shed some light on what I am doing wrong, or if it is simply something that a combo box cannot accomodate.

 

[villy]

YOu can try...

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Select Case Range("K3")
Case 3: Call EMPVILL
Case Else: 'Do Nothing
End Select
End Sub