Identifying the text box that called the macro

[lodgernz]

I want to call a macro from a text box, but I need the macro to be able to retrieve the text in the text box. I can do this OK if I know the name of the textbox object, but there will be many text boxes, and so the macro needs to know which one called it.
Is it possible for a macro to be able to get the name of the textbox that called it?

Cheers

 

[VoG]

Try Application.Caller

Sub TextBox1_Click()
MsgBox Application.Caller
End Sub

 

[Comfy]

I used the following for checkboxes, maybe it will work for textboxes??

Dim cbox As CheckBox, s As String
Worksheets(Headerpg).Unprotect
' get the name of the checkbox calling the macro
s = Application.Caller
' now set a reference to that checkbox
Set cbox = Worksheets(Headerpg).CheckBoxes(s)

so possibly

Dim cbox As Textbox, s As String
Worksheets(Headerpg).Unprotect
' get the name of the checkbox calling the macro
s = Application.Caller
' now set a reference to that checkbox
Set cbox = Worksheets(Headerpg).Textbox(s)

 

[lodgernz]

Try Application.Caller

Sub TextBox1_Click()
MsgBox Application.Caller
End Sub

Perfect!! Thank you so much.

Cheers
Roger