Goto Cell U3 When Enter is Pressed on Range Name.

[omairhe]

Hi.
Can someone kindly make a code. I want is when Enter is pressed on Range Name =Match then, Goto Cell U3

To clearify what i need is when enter is pressed on any Single Cell belonging to the Range given the name "Match" then, Goto Cell U3...

i would really appreciate any help.
Thank You.

 

[Yard]

Try:

Right-click the sheet tab and click View Code
Paste this into the code window which appears.

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Me.Range("Match")) Is Nothing Then Exit Sub
Me.Range("U3").Activate
End Sub

Press Alt+Q to return to Excel.

HTH

 

[Norie]

It is not a good idea to name a range with the same name as a worksheet function ie MATCH.

Also it really isn't clear what you are trying to do.

Why do you want Excel to 'jump' to U3 if Enter is pressed in a particular range?

 

[omairhe]

thanks for the concern...
well the range name i would certainly have to change then... i did have some doubt when naming it =match... anyways, the reason i like to do this is speedy work without using mouse to go to cell U3 which is a repetitive task after i enter data in that range name.

so if i press enter in the name range the obvious task is to go back to Cell U3 and its a repetitive and short time task that using mouse is kinda annoying so when keyboard Enter key pressed then it automatically go to cell U3...

Is possible now that i change name range to =transactions ??

thanks in advance

 

[omairhe]

Try:

Right-click the sheet tab and click View Code
Paste this into the code window which appears.

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Me.Range("Match")) Is Nothing Then Exit Sub
Me.Range("U3").Activate
End Sub

Press Alt+Q to return to Excel.

HTH

Awsome help there Yard... i didnt notice u posted an answer to this already in here....

well job well done Sir!
Thanks

 

[omairhe]

How about if i want the cell U3 to be Double-Clicked instead of Activate..
is possible? or change cell properties to be always double-click when its activated...

will appreciate help
Thank You.

 

[Yard]

Try

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Me.Range("Match")) Is Nothing Then Exit Sub
Me.Range("U3").Activate
Application.SendKeys "{F2}"
End Sub

Assuming that you don't really want to double-click, you actually want to edit the cell.

 

[omairhe]

Works....

 

[omairhe]

Try

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Me.Range("Match")) Is Nothing Then Exit Sub
Me.Range("U3").Activate
Application.SendKeys "{F2}"
End Sub

Assuming that you don't really want to double-click, you actually want to edit the cell.

No wait i actually want it to double click...because the cell has a combobox..

Sorry but could u make it assume if it is actual mouse double click.

thanks again..

 

[Norie]

What are you trying to do?

Why do you need to jump to this other cell after entering something in this range?

It really would help if you explained further - I'm pretty sure there could be another approach you could take.