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

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

"Bigweed" wrote in message
...
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

You would need to use VBA to capture the event and make any change
necessary.

Why do you want upper case input?

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Bigweed" wrote in message
...
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

Just so it could look more presentable. Oh well, guess it will have to do!!
Thanks
Bigweed

"Andy Wiggins" wrote:

You would need to use VBA to capture the event and make any change
necessary.

Why do you want upper case input?

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Bigweed" wrote in message
...
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

Bigweed wrote:
Just so it could look more presentable. Oh well, guess it will have to do!!
Thanks
Bigweed

"Andy Wiggins" wrote:


You would need to use VBA to capture the event and make any change
necessary.

Why do you want upper case input?

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Bigweed" wrote in message
...

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 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


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=393896