Displaying and Hiding Radio Boxes

L

Lester

Hello,

I need to make Radio Boxes (created using the Control Toolbox on the
Excel sheet) to appear or disappear depending on the values generated
by a formula in a given cell on the spreadsheet.

Thanks

Lester
 
M

Mark Thorpe

You'll want to set the Visible property of the option button within the
Worksheet_Calculate subroutine. For example...

Private Sub Worksheet_Calculate()
If Cells(1, 1).Value > 0 Then
OptionButton1.Visible = True
Else
OptionButton1.Visible = False
End If
End Sub
 
Top