| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format cell to uppercase using code
When K11 contains the value "QS" and it is entered in lowercase I want to
use code to convert the characters to uppercase. The cell is formatted to accept text and can contain other values. Here is my attempt at writing part of the code. Need help to complete it. If Not IsEmpty(Cells(21, 11)) Then ..Value = "qs" Thanks if you can help. Pat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom format - month as uppercase | Excel Discussion (Misc queries) | |||
| Need an UPPERCASE format ability in Excel just like Word | Excel Discussion (Misc queries) | |||
| How to format cells for uppercase entry | New Users to Excel | |||
| Format Excel column as Upper Case without use of UPPERCASE formul | Excel Discussion (Misc queries) | |||
| How to start every word in a cell uppercase? | Excel Discussion (Misc queries) | |||
Threaded Mode
