Next Cell Selection - Page 3

Page 3 of 3 FirstFirst 123
Results 21 to 27 of 27

Thread: Next Cell Selection

  1. #21
    New Member
    Join Date
    Oct 2016
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Next Cell Selection

     
    Quote Originally Posted by James006 View Post
    Hello,

    When it comes to any given game ... will the player who starts always be on the left ...?
    Unfortunately Not. Each game is started with a throw for closest to the bull so it can be either left or right. Bill.

  2. #22
    New Member
    Join Date
    Oct 2016
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Next Cell Selection

    Ok Dave I have inserted your code into the correct Modules and it all compiles ok. Excel is happy. Still no joy with the Tabbing from cell to cell even after creating the list you suggested. Bill.

  3. #23
    Board Regular
    Join Date
    Jul 2012
    Location
    Hampshire, UK
    Posts
    3,882
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Next Cell Selection

    Quote Originally Posted by Stealth2016 View Post
    Ok Dave I have inserted your code into the correct Modules and it all compiles ok. Excel is happy. Still no joy with the Tabbing from cell to cell even after creating the list you suggested. Bill.
    Sounds like getting there.

    Code works when sheet is activated - Click on another sheet then come back it & see if that works.

    Dave

  4. #24
    New Member
    Join Date
    Oct 2016
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Next Cell Selection

    Quote Originally Posted by dmt32 View Post
    Sounds like getting there.

    Code works when sheet is activated - Click on another sheet then come back it & see if that works.

    Dave
    No it doesn't work

  5. #25
    Board Regular
    Join Date
    Jul 2012
    Location
    Hampshire, UK
    Posts
    3,882
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Next Cell Selection

    Hi,

    You added a sheet name to the Const Variable that is different to the sheet you need.

    The line should read as follows:

    Public Const TabSheet As String = "Div 1"

    Edit with correct name & hopefully, all will work ok.

    To change the Tab Order, you edit cell addresses in the table as required.

    Dave

  6. #26
    New Member
    Join Date
    Oct 2016
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Next Cell Selection

    Quote Originally Posted by dmt32 View Post
    Hi,

    You added a sheet name to the Const Variable that is different to the sheet you need.

    The line should read as follows:

    Public Const TabSheet As String = "Div 1"

    Edit with correct name & hopefully, all will work ok.

    To change the Tab Order, you edit cell addresses in the table as required.

    Dave
    Dave, that works brilliantly. I have a meeting tonight with the Dart League Committee and I am sure there going to be very happy with the Score Sheet progress. (I am a Life Member of the League and am doing this so they don't have to pay out $1200.00 every 2 years for score books) Is there any way you can add another Tab Order that will do the same thing but Starting at Z7 on the score sheet then going to B7, Z8, B8,Z9,B9,AA7, C7 etc. This would then take in to account that games can start from either side of the score sheet depending on who wins the nearest to the bullseye.

    Bill Slaney.

  7. #27
    Board Regular
    Join Date
    Jul 2012
    Location
    Hampshire, UK
    Posts
    3,882
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Next Cell Selection

      
    Quote Originally Posted by Stealth2016 View Post
    Dave, that works brilliantly. I have a meeting tonight with the Dart League Committee and I am sure there going to be very happy with the Score Sheet progress. (I am a Life Member of the League and am doing this so they don't have to pay out $1200.00 every 2 years for score books) Is there any way you can add another Tab Order that will do the same thing but Starting at Z7 on the score sheet then going to B7, Z8, B8,Z9,B9,AA7, C7 etc. This would then take in to account that games can start from either side of the score sheet depending on who wins the nearest to the bullseye.

    Bill Slaney.
    Hi Bill,
    glad issue resoved & solution doing what you want.

    Solution can be adapted to include other sheets & when get time, will look at it for you (I'm on granddad duty today)

    Dave

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com