[mso] Re: Excel Question

Have a look for a selection change event handler.  It'll either be 
Worksheet_SelectionChange in the module belonging to the sheet, or 
Workbook_SheetSelectionChange in the ThisWorkbook module.

This is a simple bit of code to limit the availability to the left five 
columns.

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  If Target.Column > 5 Then
    Cells(Target.Row + 1, 1).Activate
  End If
End Sub

Note that I haven't bothered to check whether it was a tab or not that took 
you to the cell beyond Column E.  Code that only does it for a tab would 
require a keystroke interception handler which is MUCH more complicated.

Regards, Dave S

----- Original Message ----- 
From: "David Shrum" <aq392@xxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Tuesday, February 19, 2008 11:46 AM
Subject: [mso] Excel Question


> My question isn't important but it falls in the, it would be nice to know. 
> I
> downloaded a check book excel file which works great; What I would like to
> know is, who ever made the original file set it up so 'you' could use the
> tab button to jump from column to column then once it reaches the sum 
> column
> (or the last column), the next push of the tab button causes it to drop a
> line and go back to the first column, which is great. What I would like to
> know is how did they set it up so it works that way? I have set up several
> excel spread sheets for myself but would like to be able to just use the 
> tab
> button to get it to jump from column to column then drop to the next row
> back at the first column, instead of it just working its way across the 
> page
> which is what it would do now if I were to keep using the tab button.
>
>
> Thank you in advance for your help.
>
> Dave
>
>
>
> -- No attachments (even text) are allowed --
> -- Type: application/ms-tnef
> -- File: winmail.dat
>
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the 
> dropdown menu at the top.  This will allow you to unsubscribe your email 
> address or change your email settings to digest or vacation (no mail).
> http://www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister 
> group.  This group will not allow for posting of emails, but will allow 
> you to join and share problem files, templates, etc.: 
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for 
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your 
> email messages, read these instructions that explain why and how to fix 
> it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> ************************************************************* 

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: