title: Assign macro in drop down list and run with button
body: <p>I have created several macros that generates <code>ID</code>. Now I need to put them in a drop down list to be selected.</p>
  
  <p>The idea is that I'll insert a button (let's call it <code>GENERATE</code>) and a drop down list 1 cell above the button. As the value changes in the drop down list, the <code>GENERATE</code> button will generate an <code>ID</code> of a different formula accordingly. Here is my codes although I'm not sure if they are right..</p>
  
  <pre><code>Sub GenerateID()
  Dim macroName As String
  macroName = Range("A4").Value
  
  If macroName = NRIC Then
      Application.Run (GenerateNRICFIN)
  ElseIf macroName = FIN Then
      Application.Run (GenerateFIN)
  ElseIf macroName = RB Then
      Application.Run (GenerateRB)
  ElseIf macroName = RB2 Then
      Application.Run (GenerateRB2)
  ElseIf macroName = RB3 Then
      Application.Run (GenerateRB3)
  ElseIf macroName = RB4 Then
      Application.Run (GenerateRB4)
  ElseIf macroName = RB5 Then
      Application.Run (GenerateRB5)
  ElseIf macroName = RC Then
      Application.Run (GenerateRC)
  ElseIf macroName = RC2 Then
      Application.Run (GenerateRC2)
  ElseIf macroName = RC3 Then
      Application.Run (GenerateRC3)
  ElseIf macroName = RC4 Then
      Application.Run (GenerateRC4)
  ElseIf macroName = RC5 Then
      Application.Run (GenerateRC5)
  ElseIf macroName = RC6 Then
      Application.Run (GenerateRC6)
  End If
  End Sub
  </code></pre>