+ Reply to Thread
Results 1 to 11 of 11

Cell Bound to another cell

  1. 06-03-2019, 10:22 PM #1
    RJ1969
    RJ1969 is offline
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Cell Bound to another cell

    I found this code elsewhere in the net. This maybe the code that I am looking for.
    The only issue with this code is when I click, let say C1 then it bounce to another cell. Is there anyway to when I click, it will stay in the cell.
    Also, if you can add a yellow color in the cell as I press the tab?



    Please Login or Register  to view this content.
    thanks.
    Reply With QuoteRegister To Reply
  2. 06-03-2019, 11:17 PM #2
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,528

    Re: Cell Bound to another cell

    Maybe just explain what you want to achieve is the best.
    I am sure there are lots of examples on the net that "just about" do what you want.
    And besides that, everybody has there own way of doing things.
    Reply With QuoteRegister To Reply
  3. 06-03-2019, 11:37 PM #3
    RJ1969
    RJ1969 is offline
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Cell Bound to another cell

    Hi
    This is exactly was i was looking for.
    Its a tab order. My issue with this code is when i want to click in any cell, it does bot stay in it. It bounces to another cell. So when i want to edit, i cant because it bounves to another cell when i click in a cell.
    Reply With QuoteRegister To Reply
  4. 06-04-2019, 12:56 AM #4
    scottiex
    scottiex is offline
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: Cell Bound to another cell

    I take it RJ wants to press tab and for it to jump to each cell in this order
    ("A1", "A2", "A3", "C1", "C2", "C3")

    Maybe we can take over the tab key

    Please Login or Register  to view this content.
    then something similar to what you have seems to work

    Please Login or Register  to view this content.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.
    Reply With QuoteRegister To Reply
  5. 06-04-2019, 01:13 AM #5
    RJ1969
    RJ1969 is offline
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Cell Bound to another cell

    Scottiex
    Sorry, but I don't understand. Sorry...
    Reply With QuoteRegister To Reply
  6. 06-04-2019, 01:16 AM #6
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,456

    Re: Cell Bound to another cell

    @scottiex: heh, heh ... and so we start on the merry-go-round again. You need to see the OPs earlier posts about exiting a workbook and then pressing the tab key ...
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  7. 06-04-2019, 01:18 AM #7
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,898

    Re: Cell Bound to another cell

    Quote Originally Posted by RJ1969 View Post
    Scottiex
    Sorry, but I don't understand. Sorry...
    This is extremely unhelpful. What is it about the help offered that you don't understand? Be specific.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  8. 06-04-2019, 01:20 AM #8
    RJ1969
    RJ1969 is offline
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Cell Bound to another cell

    I just don't know where to place those codes :o(
    Reply With QuoteRegister To Reply
  9. 06-04-2019, 01:25 AM #9
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,898

    Re: Cell Bound to another cell

    Then your response should have gone something like this:

    "Thank you very much for helping. Would you be able to tell me where I should place the code that you have suggested?"
    Reply With QuoteRegister To Reply
  10. 06-04-2019, 01:26 AM #10
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,456

    Re: Cell Bound to another cell

    They're equivalent to Workbook Open and Workbook Close Event handlers but go in a standard module, not the Workbook module.
    Reply With QuoteRegister To Reply
  11. 06-04-2019, 01:28 AM #11
    RJ1969
    RJ1969 is offline
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Cell Bound to another cell

    Ok... Thank you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA code to select multiple columns with upper bound (j) & lower bound(i)
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 07-15-2014, 10:56 AM
  2. [SOLVED] VBA code to select multiple columns with upper bound (j) & lower bound(i)
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2014, 12:36 AM
  3. [SOLVED] Can you declare only a lower bound for an array and let the upper bound float?
    By Granite-Granny in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-20-2014, 01:40 PM
  4. Bound Combo box in userform
    By Jennifer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-16-2006, 04:10 AM
  5. Forms, Bound Columns etc
    By Michael Beckinsale in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2006, 06:55 AM
  6. Data Bound Controls in VBA??
    By Trip in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2005, 12:52 PM
  7. [SOLVED] How to get the coordinate of the lower-bound cell in Excel 2003 with C#
    By zlf in forum Excel General
    Replies: 6
    Last Post: 07-05-2005, 03:05 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1