run time error'9':subscription out of range

[khatri milan]

i wanted to disable radio buttons through vba code using this code: Worksheets("Sheet4").OptionButtons("Option Button 18").Enabled = False

but when try to run it says "run time error'9' :subscription out of range". How can i make it work.

those radio buttons are in normal worksheet not in userform and the code is inside a subroutine.

 

[My Aswer Is This]

It should look something like this:

Change sheet name as option Button name to your needs:

Private Sub CommandButton1_Click()
'Modified  11/7/2019  12:27:47 AM  EST
Worksheets("Sheet2").OptionButton1.Enabled = False
End Sub

This assumes your using a Activex Option Button

Are you sure you want it Enable=False or
Value=False

Value changes if it is selected or not selected.

 

[MARK858]

@khatri milan, if it is a Forms Option button then your syntax is a valid syntax.
Run time error'9':subscript out of range is normally a naming error (either spelling or the correct number of spaces etc.) so you need to check if you have a sheet where the tab name is Sheet4? If yes do you have an OptionButton called Option Button 18 (including the correct spacing) on the sheet with the tab name Sheet4?

When asking questions involving buttons/controls then you really should state whether they are ActiveX or Forms controls as we are trying to guess here which you are using.

 

[khatri milan]

thank you very much , it helped.sheet 4 was renamed and i was usin old name which caused the error.