Switch in VBA

[Jollywg]

I have a textbox that takes user input, and depending on what the user inputs i want to perform a formula. I know the code for Java, but not for VBA
IE textbox1 = 0

switch(Me.textbox1)
{
case 1:
a+b =c
break;

case 2:
etc.
}

Thanks

[ADezii]

I have a textbox that takes user input, and depending on what the user inputs i want to perform a formula. I know the code for Java, but not for VBA
IE textbox1 = 0

switch(Me.textbox1)
{
case 1:
a+b =c
break;

case 2:
etc.
}

Thanks

I've posted the general syntax in the AfterUpdate() Event of TextBox:

Private Sub TextBox_AfterUpdate()
If Not IsNull(Me![TextBox]) Then
'No Variables are declared
  Select Case Me![TextBox]
    Case Is < 0
      E = m * c ^ 2
    Case 0
      Pi = 4 * Atn(1#)
    Case 1 To 4
      j = -b + Sqr(453)
    Case 5, 6
      a = b + c
    Case 7
      R = Pi * R ^ 2
    Case 8
      P = 2 * (l + w)
    Case 9
      gr = Rnd()
    Case 10
      a = ((b1 + b2) / 2) * (a ^ 2)
    Case "..."      'etc., etc.
    Case Else
      'General Formula for all 'other' possibilities
  End Select
End If
End Sub