How to adjust userform width if a specific option button is selected?

[Juliame9]

Hello!

I have a userform that I want to be defaulted to a specific size, but when clicking an option button that has the value "Yes", I want the form to become wider.

I tried:
If ObYes.Value = True Then FrmCalc.Width = 732

but it doesn't do anything...
Does anyone have an idea?

Thanks!

Julia

 

[steve the fish]

You didnt say what you wanted to trigger the width change? But maybe try something like this.

Dim myWidth As Double

Private Sub UserForm_Initialize()

myWidth = FrmCalc.Width

End Sub

Private Sub ObYes_Change()

If ObYes.Value = True Then
    FrmCalc.Width = 732
Else
    FrmCalc.Width = myWidth
End If

End Sub

 

[Juliame9]

It works! Thanks you!