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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform textbox string to header causes unwanted double spacing 4
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Upper case in textbox 3
change controlsource for textbox depending on combobox selection 2
Adding a Leter to a Numerical Value on Exit 5
Textbox value as sourcerange 1
Append Text in Textbox 1
Validate Textbox/Userform Number Range 2

Back
Top