Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA
Hello from Steved
Below runs if I push a macro assigned button. Question using the below is it possible to type City and when I use the enter key it will change it to 1-City. Thankyou. Sub test1() Dim x As Long For x = 1 To Range("a" & Rows.Count).End(xlUp).Row Step 1 Select Case Left(Cells(x, 1).Value, 4) Case "City " Cells(x, 1).Value = "1-City" Case "Rosk" Cells(x, 1).Value = "2-Rosk" Case "Papa" Cells(x, 1).Value = "3-Papa" End Select Next x End Sub |