IF function or otherwise????

[Sandy]

Hi

Is it possible to have a cell value adjust depending what is typed into it?
E.g. I want to be able to type A or B or C and have the value of the same
cell change to Arnold or Brendan or Charlie respectively.

Sandy

 

[Alan]

You can have another cell change according to what you enter in to it, but
the cell itself cannot change except by using VB code. A value entered into
a cell can only change another cell, not itself. Using VB code like the
Worksheet_Change event is definitely possible, but it brings it's own
problems such as no audit trail of what you originally entered. I personally
wouldn't recommend it,
Regards,
Alan.

 

[Gord Dibben]

Taking your question literally, I would suggest using event code since a formula
and a typed entry cannot exist in the same cell.

What are you trying to achieve?

Do you have more than 3 choices or is A, B and C just an example?

There are other methods involving a formula and a helper cell to return the
result based on the entry in the cell.


Gord Dibben MS Excel MVP

 

[Alan]

Chuck,
You're first post was sent, I can see it. You may be experiencing what
happened to me and apparently quite a few others some time ago. If you go
'Find' the post is there, but it doesn't show on the listings for some
reason. I use Outlook Express but I think it happens on Outlook too. I have
no idea why, I asked questions at the time but got no satisfactory answer,
Regards,
Alan.

 

[CLR]

Thanks Alan..........I think there was a mix-up in the newsgroup the last
day or so.......lotsa missing posts, but now I think they are back or coming
back anyway.........appreciate the info.........

Vaya con Dios,
Chuck, CABGx3