Hi Christof,
I've create a class holding two textboxes as
Public WithEvents SystemBox As TextBox
Public WithEvents DescriptionBox As TextBox
However, I get the message 'object does not source automation events'
Where did I go wrong?
You need to declare them As MSForms.TextBox, as Excel has its own
TextBox object.
Regards
Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk