ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change 'ENTER' key behaviour on different cells (https://www.excelbanter.com/excel-programming/411515-re-change-enter-key-behaviour-different-cells.html)

[email protected]

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





All times are GMT +1. The time now is 09:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com