View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
costas costas is offline
external usenet poster
 
Posts: 3
Default 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"