Switch to different worksheet when value is entered

[Sherrise]

I have looked every place to try and find the answer to this. I hope someone can help!!

In worksheet1 Cell E3 when I enter a number (Value) in this cell and hit enter I want it to take me to worksheet2.

 

[My Aswer Is This]

I have looked every place to try and find the answer to this. I hope someone can help!!

In worksheet1 Cell E3 when I enter a number (Value) in this cell and hit enter I want it to take me to worksheet2.

Must it be a number or any value? And go to where on sheet2
And what is the name of worksheet2

 

[My Aswer Is This]

Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window
Put this script in sheet1
When you enter any value in Range("E3" the script will take you to sheet2 range("A1")

Private Sub Worksheet_Change(ByVal Target As Range)
'Modified  2/3/2022  5:54:24 PM  EST
If Target.Address = "$E$3" Then Application.Goto Sheets(2).Range("A1")
End Sub

 

[Sherrise]

Thank you so much for a quick turn around. I keep getting a Compile error: Syntax error

 

[My Aswer Is This]

Change the 2 to a sheet name
Like
Sheets("Alpha")