You are talking about a worksheet_change event then. So delete the selection
part

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Fan924" wrote in message
...
It does not work that well. If I enter a value of "af" and leave the
cell, nothing. When I revisit the cell, then it will change the cell
to "AF". My previous attempt changes to uppercase as I leave the cell.