option button in excel

[limeg95]

Hi!
i am trying to do when i click the option button shuld not allow to enter in range the below
what is wrong in it. is it possible?
Private Sub OptionButton60_Click()
Dim RngPST As Range
Set RngPST = Sheets("Sheet1").Range("A14:A600")
Sheets("Sheet1").Range("A14:A600").Value = ""
End Sub

 

[SkipVought]

Hi,

Please post VBA questions in forum707.

When you repost in forum707, please explain more clearly what you expect to happen. An Option Button has 2 (sometimes 3) states.

Also answer if this is a Forms control or a Control Toolbox control.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]