Posted to microsoft.public.excel.programming

Monte0682

external usenet poster

Posts: 15

about using a function for more objects

I have 5 checkboxes: checkbox1, checkbox2, etc...

I want to make a funtion

for i=1 to 5
checkboxi.enable=true
next

How to do this so I don't have to do
checkbox1
checkbox2
checkbox3
checkbox4
checkbox5

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Is it possible to use the lookup function to retrieve objects?	MAC	Excel Discussion (Misc queries)	1	May 12th 09 03:15 AM
Excel Objects and Links function grayed out	Pamela 10	Excel Worksheet Functions	1	May 22nd 08 08:05 PM
Function in objects.	Anderflash	Excel Worksheet Functions	5	July 26th 07 12:20 AM
Excel VBA Class Objects - Parent & Successor Objects	[email protected]	Excel Programming	1	January 15th 07 12:06 AM
Unable to remove Sheet objects in the Microsoft Excel Objects	Adrian[_7_]	Excel Programming	1	August 26th 04 10:49 PM

All times are GMT +1. The time now is 11:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us