Setting Default Option Value

[bluegirl_1962]

New to VBA.. I need to set a default option button value. There are three options and there is already code under a userform_initiialize(). How do I get started? Any direction would be appreciated.

 

[bluegirl_1962]

Customer.Value = True the very first line.. In the property box for the Name it is xxxxxx_option... caption is xxxxxxx

 

[Ralajer]

The Variable Name in the code has to match the name in the property pane (Name) Field. Try this out

Private Sub UserForm_Activate()

With Customer_State_Selection
.State_Combo.Clear
.Country_Combo.Clear

.Customer_Option.Value = True
.State_Option.Value = False
.Country_Option.Value = False

.State_Combo.AddItem "Nothern"
.State_Combo.AddItem "Southern"
.State_Combo.AddItem "Western"


End With
End Sub

 

[bluegirl_1962]

I noticed that the word "Customer" has focus, but the radio button is not enabled. Do I need to make another statement?

 

[Ralajer]

I can't reproduce the issue you are having. I might be missing something trying to reproduce the userform that I don't realize. So, I'm really not sure I can help anymore without access to the spreadsheet.

 

[bluegirl_1962]

Thanks... was able to determine why it wasn't working. Thought I posted a note giving thanks, because I would have never identified the issue without the assistance.. Much thanks