I am trying to identify a textbox that has been clicked
using shapes.addtextbox i added a number of text boxes
I now wonder if when selected i can recognise that it is a textbox and select the associated cell instead
I am trying to identify a textbox that has been clicked
using shapes.addtextbox i added a number of text boxes
I now wonder if when selected i can recognise that it is a textbox and select the associated cell instead
Place an example of your file
this is the code that generates the textboxes
when the user selects the textbox on the sheet I want to change the selection to the cell identified in the textbox.name![]()
Please Login or Register to view this content.
currently I do not know how to identify the selecton of a textbox only that it gains handles when selected on the sheet so some event must be happening.
see image
textbox selected.png
Last edited by incidentals; 07-07-2019 at 09:30 AM.
If these are textboxes created from the Forms toolbar and they have been assigned a macro you can identify them using Application.Caller.
That will give you the name of the control that has called the macro which you can then use to get a reference to the control and all it's properties.
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks