Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Harald - I didn't think of that. At the moment, I don't have that problem.
Later on, though (assuming I get good enough that people want more complicated stuff), that can become a problem. I will look into the custom collections - that has definite possibilities. Thanks. Ed "Harald Staff" wrote in message ... Hi Tom This is probably only a theoretical problem, but code that loops all controls might loop and test 200+ of them every time just to get something done to 5 of them. Best wishes Harald "Tom Ogilvy" skrev i melding ... for each ctrl in Userform1.controls if typeof ctrl is MSForms.Textbox then ctrl.Value = "" end if Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Link Text Boxes on Form? | Excel Discussion (Misc queries) | |||
User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
Form Text Boxes moving | Excel Worksheet Functions | |||
Newbie question: How to iterate over combo boxes on a worksheet | Excel Programming | |||
Numerical accuracy in Form Text-boxes | Excel Programming |