WithEvents - object variable declaration in class module 1

[marklenel]

I've read the excellent threads & FAQs on simulating control arrays in VBA. In trying to make this work, I'm using the following line of code in a new class module:-

Public WithEvents ButtonArray As CommandButton

...and this allows me the following event:-

Private Sub ButtonArray_Click()


However, when I try:-

Public WithEvents ButtonArray As OptionButton

...it doesn't seem to recognise the event.


Any thoughts would be more than welcome.

 

[combo]

Excel assumes that you try to refer to excel's form optionbutton (excel's library is higher than MSForms in references dialog).
Declare WithEvents with library name:
[tt]Public WithEvents ButtonArray As MSForms.OptionButton[/tt]

combo

 

[marklenel]

You beauty!

Many thanks - nice clear explanation to go with an accurate answer.