Menu

Control Arrays?

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

Jamie Collins Jamie Collins is offline

Jamie Collins is offline

external usenet poster

Posts: 593

Default

Control Arrays?

(Jamie Collins) wrote ...

You could use the class in the ThisWorkbook code module like this:

Private Chk1 As Class1
Private Chk2 As Class1
Private Chk3 As Class1

I forgot to address the subject of the thread! The above declarations
could alternatively be put into an array e.g.

Private Chks(2) As Class1

Private Sub Workbook_Open()

Set Chks(0) = New Class1
Set Chks(1) = New Class1
Set Chks(2) = New Class1
Chks(0).Init Sheet1.CheckBox1
Chks(1).Init Sheet1.CheckBox2
Chks(2).Init Sheet1.CheckBox3

End Sub

Jamie.

--

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
2007 Form Control/ActiveX Control font difference	Nikko963	Excel Discussion (Misc queries)	0	April 15th 09 04:21 PM
Control arrays on Excel 2007 userforms	Informative	Excel Discussion (Misc queries)	1	February 26th 08 09:36 PM
Tool Tip Text for Form control/ Active-X control	Freddie[_2_]	Excel Programming	0	October 19th 04 04:14 AM
Calendar Control: Can't exit design mode because control can't be created	Rone	Excel Programming	0	May 24th 04 04:01 PM
On the lack of control arrays.	Jan Nordgreen	Excel Programming	3	October 11th 03 12:11 AM

All times are GMT +1. The time now is 01:54 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement