option button group name ( can some tell me if this is posible)

Posted by steve on March 24, 2001 6:20 PM

Using the option button in the control toolbox, is it posible to link the group name box to a cell on your worksheet. I need to group lots of sets of option buttons together but the, the grouping need to be able to constently change based on events that happen on the worksheet.

thanks steve

Posted by Dave Hawley on March 24, 2001 7:49 PM

Hi Steve

Is this what you mean?

Private Sub OptionButton1_GotFocus()
Dim GrpNme As String
GrpNme = [A1]
OptionButton1.GroupName = GrpNme
End Sub

OzGrid Business Applications

Posted by STEVE on March 24, 2001 8:03 PM

THANKS DAVE THATS EXACTLY IT