I need help writing a macro that will correct typing errors?
 

I need a macro that when selected, will correct cell inputs.....
ex. What I want in the column/row of cells is AAAA.

What I have been given is AAA B, AA, AAAAA.

I would like to correct these with a macro.

Any help would be great, thanks.

I need help writing a macro that will correct typing errors?
 

You can do this with AutoCorrect. Click TOOLS and select AUTOCORRECT OPTIONS
and add what you want to trap and what you want to replace it with.

A lot easier that writing code.
--
Kevin Backmann


"notthemacroman" wrote:

I need a macro that when selected, will correct cell inputs.....
ex. What I want in the column/row of cells is AAAA.

What I have been given is AAA B, AA, AAAAA.

I would like to correct these with a macro.

Any help would be great, thanks.

I need help writing a macro that will correct typing errors?
 

Could you be a bit more specific?
Do you want any value in the cell to be changed to "AAAA" or changes
made based on some other criteria?


--
bgeier
------------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
View this thread: http://www.excelforum.com/showthread...hreadid=546048

I need help writing a macro that will correct typing errors?
 

I concur with Kevin's suggestion, however, autocorrect will change al
occurrences no matter where they are entered. You will have t
restrict (lock) cells where you do not want a user to enter data

--
bgeie
-----------------------------------------------------------------------
bgeier's Profile: http://www.excelforum.com/member.php...fo&userid=1282
View this thread: http://www.excelforum.com/showthread.php?threadid=54604