Displaying and Hiding Radio Boxes
 

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

Displaying and Hiding Radio Boxes
 

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


"Lester" wrote in message
om...
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

Displaying and Hiding Radio Boxes
 

Thanks so much it worked

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!