Calling Macro by different TextBoxes
 

Hello, Doug,
works perfectly, thank you very much!
I've tried Apllication.Caller, but wrong way ...

Jare

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

An easier approach might be

Sub Textbox_Change()
msgbox _
Activesheet.Textboxes(Application.Caller).Text
End Sub

--
Regards,
Tom Ogilvy

"Jarek" wrote in message
...

Hello, Doug,
works perfectly, thank you very much!
I've tried Apllication.Caller, but wrong way ...

Jarek


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