Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change attributes of numberous textboxes
To all
Was wondering if there was a way to change to properties (say visible) of numerous textboxes at once. I have tried a for loop with i and then textbox(i) or textbox (format (i)) and even name1= "textbox" + format (i) then name1.visible but nothing works! Is there a way to change them all or do i have to type them all out? AHGA Shawn |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
change attributes of numberous textboxes
for i = 1 to 10 userform1.Controls("Textbox" & i).Visible = False Next for a worksheet for i = 1 to 10 activesheet.OleObjects("Textbox" & i).Visible = False Next i this assumes these are textboxes from the control toolbox toolbar with names like Textbox1, Textbox2, up to Textbox10. -- Regards, Tom Ogilvy "Shawn" wrote in message ... To all Was wondering if there was a way to change to properties (say visible) of numerous textboxes at once. I have tried a for loop with i and then textbox(i) or textbox (format (i)) and even name1= "textbox" + format (i) then name1.visible but nothing works! Is there a way to change them all or do i have to type them all out? AHGA Shawn |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
change attributes of numberous textboxes
Tom
THKS!!! You saved me a whole lot of typing!! Thanks again! Shawn "Tom Ogilvy" wrote in message ... for i = 1 to 10 userform1.Controls("Textbox" & i).Visible = False Next for a worksheet for i = 1 to 10 activesheet.OleObjects("Textbox" & i).Visible = False Next i this assumes these are textboxes from the control toolbox toolbar with names like Textbox1, Textbox2, up to Textbox10. -- Regards, Tom Ogilvy "Shawn" wrote in message ... To all Was wondering if there was a way to change to properties (say visible) of numerous textboxes at once. I have tried a for loop with i and then textbox(i) or textbox (format (i)) and even name1= "textbox" + format (i) then name1.visible but nothing works! Is there a way to change them all or do i have to type them all out? AHGA Shawn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ATTRIBUTES | Excel Discussion (Misc queries) | |||
Changing attributes | Excel Discussion (Misc queries) | |||
Data value display attributes linked to table attributes | Charts and Charting in Excel | |||
How do I change font attributes in a Concatenate statement? | Excel Worksheet Functions | |||
Different text attributes... | Excel Programming |