' Determine which element of an option button control array was selected' Returns -1 if no control has been selected' Use : OptSelected = GetSelectedOption(Option1)Function GetSelectedOption(Opt As Object) As Integer Dim i As Integer GetSelectedOption = -1 For i = Opt.LBound To Opt.UBound If Opt(i).Value Then GetSelectedOption = i Exit For End If NextEnd Function
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
