+ Reply to Thread
Results 1 to 4 of 4

Color tab

  1. #1
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Color tab

    Hi,
    I have been using this color tab in my worksheet. I have someone to edit it for me but I noticed a problem (see attachment).

    When I click in any cell then color stay inside the cell.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Color tab

    What are you trying to do?
    The code adds a FormatConditions after each selection of any cell except K8 ..What is your expected output? What is the purpose of the code?
    Do you desire to highlight the active cell just when active?
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Color tab

    What the code does is when you press the tab it should tell you where you cursor is. But when you tab it supposed to follow your colortab.

    See the attachment with the regular code.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Color tab

    this was my original code:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change cell format (cell color+font color) based on color of another cell
    By Dedaluss in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2017, 03:27 AM
  2. Replies: 3
    Last Post: 05-30-2014, 10:24 AM
  3. Replies: 4
    Last Post: 12-29-2013, 11:41 PM
  4. Replies: 2
    Last Post: 02-25-2013, 03:36 AM
  5. Replies: 12
    Last Post: 09-18-2012, 03:13 PM
  6. [SOLVED] RE: Can't format cell color/text color in Office Excel 2003 in files .
    By albertaman in forum Excel General
    Replies: 0
    Last Post: 02-16-2006, 12:00 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1