Running Macro based on selection from Combo Box

[mtampa]

I think I may have posted this twice as my Internet Explorer is acting weird....I apologize if it is indeed a double-post.
==================================================
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.

 

[Andrew Poulsom]

Instead of using the LinkedCell property, use the ComboBox's Change event to update the cell.

 

[mtampa]

Instead of using the LinkedCell property, use the ComboBox's Change event to update the cell.

Can you please elaborate as to where to find this property? I have right-clicked but it is not under the "Control" tab.

 

[Andrew Poulsom]

If it's a ComboBox from the Control Toolbox right click and choose View Code. If it's from the Forms Toolbar right click and choose Assign Macro.