Assigning macros in VBA form control and active x control combo box
<p>I'm trying to assign macros to an active x combo box I already did the form control version and it works but when I try the same thing on active x I keep getting errors, what am I missing?</p>

<p>The listfillrange are on the selected cells with 30_06_16 and 29_06_16 and display fine is just when you click on the list with any date, an error appears</p>

<p>Macro1:30_06_16
Macro2:29_06_16</p>

<p>form control combo box:</p>

<pre><code>Sub DropDown13_Change()
  With ThisWorkbook.Sheets("Sheet2").Shapes("Drop Down 13").ControlFormat
    Select Case .List(.Value)
    Case "30_06_2016": 30_06_16
    Case "29_06_2016": 29_06_16
    End Select
  End With  
End Sub
</code></pre>

<p>active x combo box:</p>

<pre><code>Private Sub ComboBox2_Change()
  With ThisWorkbook.Sheets("Sheet2").Shapes("Combo Box 2").ControlFormat
    Select Case .List(.Value)
    Case "30_06_2016": Bank_Prompt_30_06_16
    Case "29_06_2016": Bank_Prompt_29_06_16
    End Select
  End With  
End Sub
</code></pre>

<p>form control is fine just active x, probably missing something obvious but any help is appreciated.</p>