Hi

You need to use Data Validation on each cell, separately. If you do this,
you can have different 'input messages' for each one.

Andy.

"Louise" wrote in message
...
Hi all

I have a large worksheet and one column contains a code consisting of two
letters. The two letters represent the name of a particular division
Division. For example, FG would mean 'Food Group', HR would mean
'Healthcare'.

As there are too many for me to remember what they all mean, is there a
way
I can click onto a cell and Excel gives me an 'input message' style box,
telling me what the code stands for?

I have tried to use Data Validation but can't get that to work as it shows
the same input message regardless of what cell I am on.

By the way, the worksheet is sorted in numerical order by another column
so
I can't sort it by the Code and then apply separate input messages.

Does anybody have any other ideas???

Thank you.

Louise