user form

I have a user form with four option buttons

if the user presses Option 1, another userform appears. if they close the second user form then they are back to the original user form.

If they wanted to press Option 1 again, they cant, as it is already selected.

How can i set the properties so that once a button is pressed, it is not stuck on that option

Thanks
Seamus
Seamus2626Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
lee555J5Connect With a Mentor Commented:
Why would you use option buttons for this? Could you switch to regular buttons?

An alternative would be to clear your option buttons once the second form opens, or you could create a manual reset so all the options are available again.

Lee
0
 
Shanan212Connect With a Mentor Commented:
Sub OptionClear()

    Dim ws As Worksheet
    Dim obj As OLEObject

    Set ws = Worksheets("yoursheetname")

    For Each obj In ws.OLEObjects
        If TypeName(obj.Object) = "OptionButton" Then      
           'if this is checkbox, then change the letters withing quotes to CheckBox
            obj.Object.Value = False
        End If
    Next obj
End Sub

Open in new window


call the above sub after calling second userform
0
 
NorieConnect With a Mentor VBA ExpertCommented:
Seamus

Why not use a combobox and command button combination?

The combobox lists the options and the command button opens the relevant userform.
UF4FormComboMenu.xlsm
0
 
Seamus2626Author Commented:
Hey guys, it was easiest to switch to regular command buttons,

Thanks
Seamus
0
All Courses

From novice to tech pro — start learning today.