Thanks Duncan

I will have a go at this.

Appreciate your time
--
Steve R


"Duncan" wrote:

Steve,

Do the validation for 2 letter codes and then put this code in,

(The code would be long and messy and look something like this,)

Private Sub Worksheet_Change(ByVal Target As Range)
Set Rng = Range("C4")

If Target = Rng Then
If Target.Value = "HD" Then
Target.Value = "Hand Deliver"
End If
If Target.Value = "DL" Then
Target.Value = "Deliver"
End If
End If

End Sub

And you would have to add all of the ifs in for each name. There will
be someone out there with a more efficient way because I am only a
beginner, but this is how I would do it as not sure how to achieve it
without code.

Let us know how you get on with this.

Duncan

Steve wrote:

This may sound daft but there are other cells that all line up to make the
whole sheet look nice.

The other option is can you select a value from the list but have a value
from another list put in the cell

e.g

Col A Col B
------ -------
Deliver DL
Customer Collect CC
Hand Deliver HD
Etc

I would have Col A in the drop down but want to put the corresponding value
in Col B.

Hope this makes sense.

Many thanks

--
Steve R


"Duncan" wrote:

Steve,

Can you not use the data validation and input the full text list, but
resize the cell on the book so it is only big enough for 2 letters?

Duncan


Steve wrote:

Hi

I'm kind of hoping that not toom much programming is required here.

What I am trying to do is have a drop down list (not on a form but using the
validation option) where the options are for example:

AN - Delivery
CU - Customer collection
etc

However, what I want to appear in the cell is just the first two letters. Is
this possible?

Many thanks

--
Steve R