textbox in a macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
 
sorry...
I make a mistake...
I want to use checkbox(i) and not textbox(i)

thanks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PowerPoint Shuffle (swap) objects on PPT slides with the same name only 0
userform exception error 4 textboxes 7
Maintaining Macros on a sheet when it is saved as a new workbook 2
Populate TextBox with other textbox value 2
Hide a textbox on open of Excel 3
Please HLEP: whats wrong with my code!? Adding textbox as runtime 3
Frames Scroll event causing cursor to move to first textbox 2
Unable to get TextBoxes property of Worksheet Class Error 14

Back
Top