SIMPLE UserForm w/ 2 OPTION BUTTONS

  • Thread starter Thread starter Chuckles123
  • Start date Start date
C

Chuckles123

Below is the code for a 'main macro' and code for each of two Optio
Buttons.
You may find this useful in situations when you want to direct contro
to either of two sections of code based upon user selection o
alternatives presented.

Public Button As String
Sub CREATE_FORM()
'
frmPricing.Show
'SHOW Pricing UserForm ON DISPLAY

'USER SELECTS BUTTON

'AFTER SELECTION, CONTROL COMES BACK HERE
If Button = "EVAL" Then
Range("A1").Select

Else
Range("C1").Select
End If

End Sub

‘BELOW IS CODE FOR EACH OF 2 OPTION BUTTONS

Private Sub optEVAL_Prices_Click()
Button = "EVAL"
Unload Me
End Sub

Private Sub optBID_Prices_Click()
Button = "BID"
Unload Me
End Sub

The only missing steps are the assignment of a programmatic name and a
UserForm name to each of the Option Buttons, a Frame around the Button
(if so desired), and the UserForm itself.

You may find this useful in lieu of a MsgBox.

Chuckles12
 
It might be better to make code offered like this more generic, such as
adding constants for string values so that the number of customisations are
minimised. Not a big deal here, but with bigger code samples it can save
pain.
 
Back
Top