automatic charactor replacement
I have a column in which want to automatically control information entered.
As an example if someone enters XYZ I want it to automatically change to ABC. |
automatic charactor replacement
hi
auto correct options. 2003 on the menu bar... toolsauto correct options type in what you want replaced and what to replace it with. Regards FSt1 "Jerry" wrote: I have a column in which want to automatically control information entered. As an example if someone enters XYZ I want it to automatically change to ABC. |
automatic charactor replacement
You can use this worksheet Change event to do that...
Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo FixItUp If Target.Column = 4 Then If UCase(Target.Value) = "XYZ" Then Application.EnableEvents = False Target.Value = "ABC" End If End If FixItUp: Application.EnableEvents = True End Sub My example code above applies this functionality to Column D... change the test in the first If..Then statement to the column number you want it applied to. As written, it is case sensitive requiring an all upper case XYZ. If you want case insensitivity, change the second If..Then statement to this instead... If UCase(Target.Value) = "XYZ" Then -- Rick (MVP - Excel) "Jerry" wrote in message ... I have a column in which want to automatically control information entered. As an example if someone enters XYZ I want it to automatically change to ABC. |
automatic charactor replacement
ToolsAutocorrect
Roll your own. I'm sure there are more cases than just your example so post back with more details if you want code. Gord Dibben MS Excel MVP On Thu, 11 Sep 2008 13:22:13 -0700, Jerry wrote: I have a column in which want to automatically control information entered. As an example if someone enters XYZ I want it to automatically change to ABC. |
All times are GMT +1. The time now is 03:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com