How to automatically change a single letter text entry to caps??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi to everyone

Hopefully someone can help! I have a spreadsheet where users input a letter
from a to z into a textbox. How can I make Excel convert this letter to a
capital letter automatically, in case someone enters it as a lowercase
letter? Dont know if this can be done, but hoping it can!! I know about the
UPPER function, but that is not quite what I need as that function enters the
letter as uppercase into another textbox. I need it as uppercase in the
textbox in which it is entered.

Many thanks
Bigweed
 
I asked a similar question some while ago and received the answer that it
can't be done. I think you'll need a cell "as input" and a cell "input"
which tests for the input and returns information in the required format.

Regards.

Bill Ridgeway
Computer Solutions
 
You would need to use VBA to capture the event and make any change
necessary.

Why do you want upper case input?
 
Just so it could look more presentable. Oh well, guess it will have to do!!
Thanks
Bigweed
 
Bigweed said:
Just so it could look more presentable. Oh well, guess it will have to do!!
Thanks
Bigweed

:
Click to expand...

I use a small program called ASAP Utilities. It can be found at:

http://www.asap-utilities.com/

It has many useful tools one being convert text to upper case under the
options. It's free and has no ads. I find it quite useful.

One thing to remember is that the changes made can't be undone with
the undo button so make sure you have a backup copy before using the
tool.

Standard disclaimer: I'm in no way associated with ASAP utilities nor
do I receive any monetary compensation for promoting their product.

gls858
 
Depending on how many options the users have for inputting a single
letter (how long of a pick list is too long for your users?), you could
use Data Validation and assign a List of Letters (all CAPS, of course)
from which the user can choose their desired letter.

Just another (non-addin, non-macro) option...

Cheers,

Bruce
 
Back
Top