View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sweetpotatop@yahoo.com is offline
external usenet poster
 
Posts: 5
Default loop through textbox in Excel

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.