Sorry about this question but I am new,

on exit from a textbox I want it to convert automatically to capitals, how
do I do this please?

Here is some of my code

NEW3.Value = Format(TextBox1.Value, "A")

Thanks

Greg