Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to return a number into letters? | Excel Worksheet Functions | |||
return random letters - an example | Excel Programming | |||
Return column letters to spreadsheet. | Charts and Charting in Excel | |||
VBA function to return letters of alphabet | Excel Programming |