Calling Macro by different TextBoxes

  • Thread starter Thread starter Jarek
  • Start date Start date
J

Jarek

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
 
Jarek,

I think this will do it:

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

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

Doug Glancy
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

referencing controls in userform from a different workbook 2
why does s.TextFrame.Characters.Text work only sometimes? 7
How to call Excel add-in macro from a button… 1
Run one Macro from clicking different Textbox Objects 1
Forms Textbox and Assign Macro 7
Make Macro Work On A Different PC 5
Calling routines from different sheets 1
OnTime Change_Event macro AND copy to sheet2 macro trouble 7

Back
Top