Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically Change Text in Cell
Hi,
I am not sure but there maybe a really easy way to do this. If a user enters "B" in cell A1 how could I automatically change the "B" to "Brazil" for example? I am looking to create a calendar so when the users enters "B" for a given date "Brazil" will appear instead of "L". Thanks, Brett |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically Change Text in Cell
Maybe try playing with Tools AutoCorrect Options?
Replace: B With: Brazil Click Add OK -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- " wrote: Hi, I am not sure but there maybe a really easy way to do this. If a user enters "B" in cell A1 how could I automatically change the "B" to "Brazil" for example? I am looking to create a calendar so when the users enters "B" for a given date "Brazil" will appear instead of "L". Thanks, Brett |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically Change Text in Cell
Right click sheet tabview codeinsert this to do what you said.
However, I suspect you want a bit more to involve a larger target range and more choices. You would want a select case statement. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("a1")) Is Nothing Then If UCase(Target) = "B" Then Target = "Brazil" End If End Sub -- Don Guillett SalesAid Software wrote in message oups.com... Hi, I am not sure but there maybe a really easy way to do this. If a user enters "B" in cell A1 how could I automatically change the "B" to "Brazil" for example? I am looking to create a calendar so when the users enters "B" for a given date "Brazil" will appear instead of "L". Thanks, Brett |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stumped: If a cell contains a formula, can you make text color automatically change? | Excel Worksheet Functions | |||
Change text color in a cell automatically | Excel Discussion (Misc queries) | |||
automatically change text case on entry | Excel Discussion (Misc queries) | |||
How do I automatically change text | Excel Discussion (Misc queries) | |||
Automatically change text to uppercase | Excel Worksheet Functions |