ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Defaulting test to Upper case (https://www.excelbanter.com/excel-worksheet-functions/158077-defaulting-test-upper-case.html)

Skippy

Defaulting test to Upper case
 
Hi

Is it possible to have test within excel default to Upper case?

thaks

Peo Sjoblom

Defaulting test to Upper case
 
Did you mean text? If so then you made a double typo

You would need an event macro

http://www.mvps.org/dmcritchie/excel/proper.htm


scroll down to upper


--

Regards,

Peo Sjoblom
"Skippy" wrote in message
...
Hi

Is it possible to have test within excel default to Upper case?

thaks




T. Valko

Defaulting test to Upper case
 
You would need an event macro

Turn on the caps lock key?

--
Biff
Microsoft Excel MVP


"Peo Sjoblom" wrote in message
...
Did you mean text? If so then you made a double typo

You would need an event macro

http://www.mvps.org/dmcritchie/excel/proper.htm


scroll down to upper


--

Regards,

Peo Sjoblom
"Skippy" wrote in message
...
Hi

Is it possible to have test within excel default to Upper case?

thaks






Peo Sjoblom

Defaulting test to Upper case
 
Then remove the caps lock key so it can't be pushed again LOL


--
Regards,

Peo Sjoblom



"T. Valko" wrote in message
...
You would need an event macro


Turn on the caps lock key?

--
Biff
Microsoft Excel MVP


"Peo Sjoblom" wrote in message
...
Did you mean text? If so then you made a double typo

You would need an event macro

http://www.mvps.org/dmcritchie/excel/proper.htm


scroll down to upper


--

Regards,

Peo Sjoblom
"Skippy" wrote in message
...
Hi

Is it possible to have test within excel default to Upper case?

thaks









All times are GMT +1. The time now is 04:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com