tab order

[rsrc1147]

I am sure that this has been asked before but I can't find it on the pages;

Is it possbile to mkae excel jump to a set cell when someone presses enter? eg, if someone types in a fgure in cell A1, is it possible for them to go straight to, say, C12 when they press enter or tab or whatever? This isn't particularly urgent, it's just really bugging me now. Cheers Ears

 

[NateO]

Howdy rsrc1147, a worksheet_change event is of particular use for this type of operation:

<pre>
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, [a1]) Is Nothing Then [c12].Activate
End Sub</pre>

Right-click on your sheet tab, click view code, and paste the above procedure in the now opened worksheet module.

 

[rsrc1147]

Thankyou Very much, a weight has been lifter off my otherwise lithe shoulders.

 

[rsrc1147]

Errr, actually I hat to say this but it's not doing anything. I have pasted it the code and made sure it says Worksheet Change at the top but nothing is happening when I go back onto the sheet. I hate to sound thick but is there like an 'on' button or something I need to press? Thanks, I am sorry about my ineptness.

 

[NateO]

Hello, two things, you must be in the worksheet that you pasted the code in (its module as described above). And the code must look exactly as it does above, inclucding: byval target as range.

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2002-11-06 19:51

 

[rsrc1147]

Check. Still not doing anything. I m really sorry about this.

 

[NateO]

And it only works for a1 (as written), you can change the [a1] to the range of your choice, e.g., [b10:z100]

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2002-11-06 19:52

 

[rsrc1147]

Ummm, it's not working for either