Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change 'ENTER' key behaviour on different cells
Much much better.
Thanks. How do you capture cell I3 so it calls a Sub? On May 26, 11:40*am, JLGWhiz wrote: This might work better. Private Sub Worksheet_Change(ByVal Target As Excel.Range) Set Target = Intersect(Target, Range("B3:H4")) *If Not Target Is Nothing Then * *Target.Offset(0, 1).Activate *End If End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change 'ENTER' key behaviour on different cells | Excel Programming | |||
Change 'ENTER' key behaviour on different cells | Excel Programming | |||
change autofilter behaviour? | Excel Discussion (Misc queries) | |||
simulate a enter key behaviour? | Excel Programming | |||
how to change (override) enter key behaviour in a cell | Excel Programming |