View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
costas costas is offline
external usenet poster
 
Posts: 3
Default macro with checkbox(i)

I have a workbook with 4 worksheets
In a userform with 4 checkboxes i want to check if the sheets are visible
and if is true change the value of these checkboxes

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

the problem is that is not recognize the checkbox(i) and give
me a compile error
"sub or function not defined"