S S. Kissing Jul 24, 2009 #1 I want any text added in a cell to automatically change to uppercase even if the user adds in lower case. Please help....
I want any text added in a cell to automatically change to uppercase even if the user adds in lower case. Please help....
M Mike H Jul 24, 2009 #2 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
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
