Hi there. I've got some activex textboxes in a sheet with some default text in them. Once the user clicks on a particular textbox, I want to clear the default text in that textbox so that the user can add their own text without having to first select the existing text and then delete it.
So I'm using this:
But because I'm doing this with a lot of text boxes, I want to have a function that does this, that automatically gets passed the name of the calling activex object.
Can someone steer me in the right direction of how I can pass the activex name/details to the function, and how I would dim the activex name/details within that function?
Thanks
So I'm using this:
Code:
Private Sub TextBox1_GotFocus()
If Sheet1.TextBox1.Text = Range("TextBox1_default").Value Then Sheet1.TextBox1.Text = ""
End Sub
But because I'm doing this with a lot of text boxes, I want to have a function that does this, that automatically gets passed the name of the calling activex object.
Can someone steer me in the right direction of how I can pass the activex name/details to the function, and how I would dim the activex name/details within that function?
Thanks