variable in object name

Posted to microsoft.public.excel.programming

kaptenn

external usenet poster

Posts: 3

variable in object name

I have checkboxes with names from checkbox1 to checkbox20
if I try
sub whatever()
for i=1 to 20
if checkbox(i).value=true then
do sumething
end if
next i
end sub
I get error message that sub or function not defined. How to fix that?

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
Runtime Error '91' Object variable or With block variable not set	Alec Coliver	Excel Discussion (Misc queries)	2	October 24th 09 02:29 PM
Object Variable Not Set Error on Selection object	Jean	Excel Worksheet Functions	3	July 24th 06 06:45 PM
Run-time error '91': "Object variable or With block variable not set	Mike[_92_]	Excel Programming	2	December 30th 04 10:59 AM
Cells.Find error Object variable or With block variable not set	Peter[_21_]	Excel Programming	2	May 8th 04 02:15 PM
Pivot Table - Object variable or with block variable not set?	George Nicholson[_2_]	Excel Programming	1	April 16th 04 09:12 PM

All times are GMT +1. The time now is 10:55 PM.

Menu

About Us