Creating new option for excel program

[Guest_imported]

I am a first time VB user. I am trying to incorporate and new product into an existing excel program.
The error I recieve when running the macro is Subscriot out of range. What does that mean?


This is the code which it highlights when debugging.

ElseIf OptionButton16.Value = True Then
Worksheets("CBRB").Select

This is the same as all of the other option button.
Please help!

 

[BrainB]

"Subscript out of range" basically means that in a collection of the same type of object you are trying to access one outside the .Count value. In your 2 lines of code this could refer to either the OptionButtons() or Worksheets() collections. I would guess, for example, that you do not have an option button called "OptionButton16". Regards
BrianB
** Let us know if you get something that works !
================================