Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a module containing 'Dim ChkBoxes() As New Class1' and Class module
with 'Public WithEvents CBXGroup As MSForms.CheckBox'. All of the ChkBoxes work perfectly. When I place an OptionButtons on this form I get an error. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Did you try putting two option button on the form? If you have a Group it
expects more than one button. "PJ Murph" wrote: I have a module containing 'Dim ChkBoxes() As New Class1' and Class module with 'Public WithEvents CBXGroup As MSForms.CheckBox'. All of the ChkBoxes work perfectly. When I place an OptionButtons on this form I get an error. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
No, there can be a group with one member.
Did you change the declaration to MSForms.OptionButton? - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - Training in Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "joel" wrote in message ... Did you try putting two option button on the form? If you have a Group it expects more than one button. "PJ Murph" wrote: I have a module containing 'Dim ChkBoxes() As New Class1' and Class module with 'Public WithEvents CBXGroup As MSForms.CheckBox'. All of the ChkBoxes work perfectly. When I place an OptionButtons on this form I get an error. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Set Class1Var = New Class1 | Excel Programming |