3 replies
by patricia.lynn Accepted solution
by bizzo Accepted solution
Need a macro to do this if you want it all in a single cell. Select the code page for the worksheet, select the dropdown at the top left (which should say '(general)'), pick 'Worksheet' then select the 'Change' member of the dropdown on the right.
Change this function to:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1:A1")) Is Nothing Then
Exit Sub
Else
For Each x In Range("A1:A1")
x.Value = UCase(x.Value)
Next
End If
End Sub
This means that whenever the contents of cell A1 (or whatever you set the range to) changes, it will change the contents to upper case.
by patricia.lynn Accepted solution
This discussion is closed to new replies.
Trending Software posts
Sort by Trending