Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert lower to upper case automatically without using UPPER | Excel Discussion (Misc queries) | |||
Changing upper case characters to upper/lower | Excel Discussion (Misc queries) | |||
Changing file in all upper case to upper and lower case | Excel Discussion (Misc queries) | |||
Upper case in textbox | Excel Programming | |||
How do I convert all upper case excel sheet into upper and lower . | Excel Discussion (Misc queries) |