| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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" |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'Find' textbox value macro | Excel Discussion (Misc queries) | |||
| a macro that Formats a textbox based on value in a cell | Excel Worksheet Functions | |||
| How to move cursor from one textbox control to another textbox con | Excel Programming | |||
| Excel VBA/Macro - Textbox | Excel Programming | |||
| UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming | |||
Hybrid Mode
