Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calling Word from an .xlm macro: how to? | Excel Programming | |||
problem when drawing textboxes in excel using macro | Excel Programming | |||
Calling a macro from an IF statement | Excel Programming | |||
Calling a .Net Procedure from a Macro | Excel Programming | |||
Calling macro in add-in. | Excel Programming |