Form Control Combo Box Selection

Hello,
how do you run a macro according to the selection made in a form control combo box?

essentially whatever I have selected in the combo box I want filtered in a table, the cell which is the table header i need the filter on is in A10 and called 'Order No' of the 'Prt2Rec' table

Please help

Hi,

You can access the contents of the combo box just like the contents of a normal text box, i.e.

ComboBoxName.Text

will give you the content of the combo box.

Hi Philip,
I'm not sure I understand? The values are from a range of cells on the sheet, but I would like to filter the table below according to the value selected in the form control combo box. eg 3004
*the table column I would like to filter according to the value selected in the combo box is in A:10 [Order No]

ok!! I've worked it out :D

Silly me didn't know where to look to find the form control name :p (top left, where cell reference is)

So... after renaming my combo [cmbPO], I created a macro to filter the table on the Order number field for each value in the drop down:

Sub Records3004()
' Records3004 Macro
    Range("GE_Prt2Rec[[#Headers],[Order No]]").Select
    ActiveSheet.ListObjects("GE_Prt2Rec").Range.AutoFilter Field:=1, Criteria1 _
        :="3004"
End Sub

and then associated the following code with the combo box:

Sub RuncmbPO()
    With ThisWorkbook.Sheets("POs").Shapes("cmbPO").ControlFormat
        Select Case .List(.Value)
            Case "3004": Records3004
            Case "3005": Records3005
            Case "3006": Records3006
            Case "3007": Records3007
            Case "3008": Records3008
            Case "3009": Records3009
            Case "3010": Records3010
        End Select
    End With
End Sub

it might be a little clumsy but it workd :D thankyou for you help