ExcelBanter - Uppercase

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Uppercase (https://www.excelbanter.com/excel-discussion-misc-queries/237918-uppercase.html)

S. Kissing

Uppercase

I want any text added in a cell to automatically change to uppercase even if
the user adds in lower case. Please help....

Mike H

Uppercase

Hi,

Right click your sheet tab, view code and paste the code below in on the right

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Formula = UCase(Target.Formula)
End Sub

Mike

"S. Kissing" wrote:

I want any text added in a cell to automatically change to uppercase even if
the user adds in lower case. Please help....

All times are GMT +1. The time now is 03:00 PM.