New to Forms - string based on command button

[288enzo]

First post regarding a User Form.

I'd like to run a form with a list of command buttons. I have one macro, when a command button is clicked from EmailForm, the macro continues and depending on which command button is clicked a string is set as such.

As an example -

Dim class As String

Based on which command button is clicked on -
CommandButton1, class = 1
CommandButton2, class = 2
CommandButton3, class = 3
CommandButton4, class = 4

What's the best way to accomplish this?

Thank you,

 

[6StringJazzer]

You need an event handler for each button on the form.

Private Sub CommandButton1_Click()

   class = 1

End Sub

and so on.