Align TextBox Within A Range

[Anshu]

Where and how does the text box get its text from?

It is manually typed in by the user.

Does a macro put text into it?

No, not at all. Neither any linked cell formula, nor any macro. Just typing manually.

Macros nearly always clear the undo stack - there's no avoiding it.

This is really a big issue, then. May be, using change event instead of selection event may help! Can we declare an object like TextBox as Target??