Upper case in textbox
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 |
Upper case in textbox
Sorry i never changed the code to the right box
Thanks Greg "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 |
Upper case in textbox
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 |
All times are GMT +1. The time now is 06:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com