Upper case in textbox

  • Thread starter Thread starter Greg B
  • Start date Start date
G

Greg B

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
 
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)
 
Back
Top