Hello,
First time poster, please be gentle.
Working with Excel 2007.
I'm trying to have a cell display the day of the week when a date in entered in another cell. I'm using =TEXT(B4,"DDDD") which works but the day is in proper case.
I tried using the code below that I found on another site. It works, but only once.
If use a different date it does not update the cell with the correct day of the week.
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Target.Value = UCase(Target.Value)
Application.EnableEvents = True
End Sub
Appreciate any help.
First time poster, please be gentle.
Working with Excel 2007.
I'm trying to have a cell display the day of the week when a date in entered in another cell. I'm using =TEXT(B4,"DDDD") which works but the day is in proper case.
I tried using the code below that I found on another site. It works, but only once.
If use a different date it does not update the cell with the correct day of the week.
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Target.Value = UCase(Target.Value)
Application.EnableEvents = True
End Sub
Appreciate any help.