Greg,

NEW3.Value = Format(TextBox1.Value, "A")
should be
NEW3.Value = UCase(TextBox1.Value)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Greg B" wrote in message
...
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