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.
Bookmarks