Hi
I have a userform with multiple optionbuttons in a frame. When i launch the userform i want the value og the optionbox that has the same caption as cell A2 in worksheet "Enhet", to be TRUE. Hope I explained it OK. I have tried the code below. But I have never tried this before, så it may be way of...
![]()
Sub enhet_valg() Dim x As Control For Each x In UserForm1.Frame1.Controls If Worksheets("Enhet").Range("A2").Text = x.Caption Then x.Value = True End If Next x End Sub
Bookmarks