loop through textbox in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sweetpotatop@yahoo.com - 24 Jan 2006 15:50 GMT

In my Excel 2003, I have around 30 textbox, which is created by using
the following formula

=EMBED("Forms.TextBox.1","")

I wonder how can I loop them through my VB editor within excel. I have
try using

me.controls
msforms.textbox
OLEObjects

But none of them recognize what I am trying to do. So what is the
syntax for getting all these controls?

Thanks in advance and your help would be greatly appreciated.

Reply to this Message

Tom Ogilvy - 24 Jan 2006 16:00 GMT

Dim obj as OleObject
Dim tbox as MSForms.TextBox
for each obj in ActiveSheet.OleObjects
if typeof obj.Object is MSforms.TextBox then
set tbox = obj.Object
msgbox tbox.Name & " - " & tbox.Value
end if
Next

Signature

Regards,
Tom Ogilvy

> In my Excel 2003, I have around 30 textbox, which is created by using
> the following formula
[quoted text clipped - 12 lines]
>
> Thanks in advance and your help would be greatly appreciated.

Reply to this Message

galimi - 24 Jan 2006 16:01 GMT

You can loop through them using the Shapes collection under the particular
Sheet object.

Signature

http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758

> In my Excel 2003, I have around 30 textbox, which is created by using
> the following formula
[quoted text clipped - 12 lines]
>
> Thanks in advance and your help would be greatly appreciated.

Reply to this Message