Re: Force a cell to show entered text in Upper case albelina, It may be that you have interrupted the program and that EnableEvents is currently switched off (it doesn't automatically reset when the program ends). Try the following steps: 1) Go to the Visual Basic Editor (Alt + F11) 2) Open the Immediate Pane (Ctrl + G) 3) Click into the Immediate Pane and enter: Application.EnableEvents = True (Enter) 4) Return to the worksheet and re-test. Steve, You need to process each cell separately. Try replacing your code with the following. Code: Private Sub Worksheet_Change(ByVal Target As Excel.Range) Dim rngCell As Range If Intersect(Target, Range('A1:D100')) Is Nothing Then Exit Sub Application.EnableEvents = False For Each rngCell In Target.Cells rngCell = UCase(rngCell) Next Application.EnableEvents = True End SubHope this helps.

Mac computers include a feature that can do this automatically for you without the need to download additional software. Winzip for mac 10.6 free download. You can change any text to uppercase or lowercase, as well as capitalize the first letter of every word if needed.

Regards, Batman.[/QUOTE] Batman, I want to use this code to do something slightly different. Can you help me please? I want to force a cell within the range I set to default to Tahoma size 8 font in black text. How can I add these bits to the code above please? Thanks and have a great day. We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity.

We may share certain information about our users with our advertising and analytics partners. How to unlock mac word doc for editing. For additional details, refer to our. By clicking ' I AGREE' below, you agree to our and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.