Calling Macro by different TextBoxes
 

Hello,
I have set of textboxes (msoTextBox, Shape.Type = 17), each of the
assigned to the same macro. I need to know, which of textboxes calle
the macro, then use .TextFrame.Characters.Text as parameter for thi
macro.
Can you help me?
Maybe it isn't clear, but I have problem with my English to explain i
better.

Thanks,
Jarek, Czech Republi

--
Jare
-----------------------------------------------------------------------
Jarek's Profile: http://www.excelforum.com/member.php...info&userid=96
View this thread: http://www.excelforum.com/showthread.php?threadid=26830

Calling Macro by different TextBoxes
 

Jarek,

I think this will do it:

MsgBox
Worksheets("Sheet1").Shapes(Application.Caller).Te xtFrame.Characters.Text

By the way, your question was very clear (and your English is much better
than my Czech)!

Doug Glancy

"Jarek" wrote in message
...

Hello,
I have set of textboxes (msoTextBox, Shape.Type = 17), each of them
assigned to the same macro. I need to know, which of textboxes called
the macro, then use .TextFrame.Characters.Text as parameter for this
macro.
Can you help me?
Maybe it isn't clear, but I have problem with my English to explain it
better.

Thanks,
Jarek, Czech Republic


--
Jarek
------------------------------------------------------------------------
Jarek's Profile:
http://www.excelforum.com/member.php...nfo&userid=965
View this thread: http://www.excelforum.com/showthread...hreadid=268307