I have a textbox created from the forms toolbar, floating on a worksheet
(it's not in a form).
I want to be able to enter text in this box, and then, when I change the
focus back to the sheet (or, better, press TAB), a macro is launched.
I am able to Assign a Macro to the textbox, but when I click the textbox
(to enter text), the macro launches. Now I have to rightclick to select
the text box and enter text. Not ideal.

Is there some way of capturing the shift in focus from the textbox to the
worksheet in a worksheet event? Or is there another way?

I know I can do this with a Controls Textbox, but I'd like to stick with
the Forms one if I can (I have other stuff based on it).

Is what I'm seeking possible?
Thanks in advance,
------------------
Darren