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

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

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