Is there any way to detect that a form is in design mode (opened from
Tools-Forms-Design A Form), from addin's NewInspector event handler (C#
or VB.Net), not from the form's vba code?

If it is design mode, no code in the event handler should be ran.