Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reset 108 text boxes
Hi all,
I need to reset 108 text boxes, is there a way to do them all at once without unloading the form ? Tempy *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reset 108 text boxes
Dim ctl as Control
for each ctl in Userform1.controls if typeof ctl is MsForms.TextBox then ctl.Value = "" end if Next -- Regards, Tom Ogilvy "Tempy" wrote in message ... Hi all, I need to reset 108 text boxes, is there a way to do them all at once without unloading the form ? Tempy *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reset 108 text boxes
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form Text Boxes - Copy format of text boxes | Excel Discussion (Misc queries) | |||
Reset row hight after string of text edit on a cell | Excel Discussion (Misc queries) | |||
Reset Text Direction in Formal Cells Menu | Excel Discussion (Misc queries) | |||
How do I link Text Boxes to Cells, not Cells to Text Boxes? | Excel Worksheet Functions | |||
Text to columns -- reset delimiters, etc | Excel Programming |