Insert string in active text box only

I have this macro which takes a variable number of selected cells and puts them in a form. There is a button which inserts the character "#" at the cursor location.
If I place the cursor in the first textbox it will work, it will insert the character at the cursor location. When I get to the second and subsequent textboxes, it REMEMBERS the cursor location from the previous selection and it will insert the character in the previous textboxes again, even though the cursor is not there. So by the "n-th" textbox selection, it will insert the character in all "n" textboxes. I only want to insert the character in the text box where the cursor is.
Is there a way to specify the active textbox only?

BeforeAndAfter.png

FORM CODE

Please Login or Register  to view this content.

Hi,

there is not any gotfocus event for textbox. Once you click the button a textbox is not the active control... My opinion is that it is not possible to do it in excel userform or would be bit difficult task.

If the goal is to insert some (same) string to the position of a cursor in each box then I'd put a mark (like #) to every box manually. And under Button use replace method.

s.

You're right.
There is an example here which uses module classes: http://yoursumbuddy.com/raiseevent-m...form-controls/
But this if when textbox is written into. I can't exactly use this one because I will have characters that can't be typed in.