Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to access all the textboxes inside a frame?
I have some 10 text boxes inside a frame. how can i iterate through
them? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to access all the textboxes inside a frame?
something like following may do what you want:
Dim i As Integer For i = 1 To 10 Controls("TextBox" & i).Text = i Next -- JB "Yajiv" wrote: I have some 10 text boxes inside a frame. how can i iterate through them? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to access all the textboxes inside a frame?
This code will find each of them for you...
Dim C As Control For Each C In Me.Controls If C.Parent.Name = "Frame1" Then If TypeName(C) = "TextBox" Then ' ' You found a TextBox inside Frame1 ' Put your code for it here. ' End If End If Next Rick "Yajiv" wrote in message ... I have some 10 text boxes inside a frame. how can i iterate through them? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
frame control inside an image control | Excel Programming | |||
VLOOKUP used with Access DB inside of Excel Sheet | Excel Discussion (Misc queries) | |||
Run Excel VBA code inside Access | Excel Discussion (Misc queries) | |||
How to access a Radio Button in Frame in Excel? | Excel Programming | |||
How to attach legend frame to chart frame? | Charts and Charting in Excel |