Is this what you are looking for...

Select Case Left$(Target.Value, 2)

Rick


"RyanH" wrote in message
...
I have a BeforeDoubleClick_Event that I want to use to intialize different
Userforms. My users will click on certain cells that contain reference
numbers. Each number starts with two capital letters. The two letters
will
dictate which Userform is Initalized. How can I extract the first two
letters of the cell value. For example:

Select Case (FIRST TWO LETTER OF TARGET)

Case PF
'code'
Case EC
'code'

End Select

Thanks in Advance,
Ryan