textbox in a macro
 

I have a workbook with 4 sheets. In a form with 4 textboxes. If the sheets
are visible I want to change the value of these textboxes

for i= 1 to 4
if sheets(i).visible=true then
textbox(i).value = true
end if
next i

the problem is that the command textbox(i) is not recognized by excel
I receive message

"compile error sub or function not defined"

textbox in a macro
 

sorry...
I make a mistake...
I want to use checkbox(i) and not textbox(i)

thanks

"costas" wrote:

I have a workbook with 4 sheets. In a form with 4 textboxes. If the sheets
are visible I want to change the value of these textboxes

for i= 1 to 4
if sheets(i).visible=true then
textbox(i).value = true
end if
next i

the problem is that the command textbox(i) is not recognized by excel
I receive message

"compile error sub or function not defined"

textbox in a macro
 

See you first posting of this question for sample code.

--
Regards,
Tom Ogilvy

"costas" wrote in message
...
sorry...
I make a mistake...
I want to use checkbox(i) and not textbox(i)

thanks

"costas" wrote:

I have a workbook with 4 sheets. In a form with 4 textboxes. If the
sheets
are visible I want to change the value of these textboxes

for i= 1 to 4
if sheets(i).visible=true then
textbox(i).value = true
end if
next i

the problem is that the command textbox(i) is not recognized by excel
I receive message

"compile error sub or function not defined"