+ Reply to Thread
Results 1 to 3 of 3

Highlight active cell or range for visiblity purposes.

  1. #1
    Forum Contributor
    Join Date
    05-02-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2016
    Posts
    190

    Highlight active cell or range for visiblity purposes.

    Hello, I am having difficulty get this macro to work correctly, does anyone see my problem? I would like to high light the active cell yellow (or range) when I click on it or arrow to a cell. Then when I move off of the cell, I would like to restore its original attributes. It seems I would record the original attributes, highlight it yellow, and when I move off the cell restore the attributes. The code changes the cell yellow; however, it does not restore the original color. I have a few lines of code I have messaged out because they do not work. I would appreciate any help you could give me. Thanks Redsab
    Please Login or Register  to view this content.
    Last edited by redsab; 10-06-2020 at 12:16 PM. Reason: Add excel sheet

  2. #2
    Forum Contributor
    Join Date
    05-02-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2016
    Posts
    190

    Re: Highlight active cell or range for visiblity purposes.

    Hello, I am having difficulty get this macro to work correctly, does anyone see my problem? I would like to high light the active cell yellow (or range) when I click on it or arrow to a cell. Then when I move off of the cell, I would like to restore its original attributes. It seems I would record the original attributes, highlight it yellow, and when I move off the cell restore the attributes. The code changes the cell yellow; however, it does not restore the original color. I have a few lines of code I have messaged out because they do not work. I would appreciate any help you could give me. Thanks Redsab
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    05-02-2013
    Location
    Indiana
    MS-Off Ver
    Excel 2016
    Posts
    190

    Re: Highlight active cell or range for visiblity purposes.

    Well, no body responded, so I ended up changing my method. I highlight the rows and column based on the active cell and used conditional formatting just on my data selection to change the color. I also added a small VBA program to allow for Cut/Copy/Paste option. This is a great way for those Excel'ers that have a hard time finding where the active cell is. The little green boarder around the active cell is hard to see. Thanks Redsab.
    Attached Files Attached Files

+ 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. [SOLVED] If active cell value dosn't match in range then highlight the active cell
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-18-2017, 12:38 AM
  2. Highlight active cell
    By calsam1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2016, 11:24 AM
  3. [SOLVED] Highlight active cell, un-highlight when no longer active?
    By cdterry in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2013, 02:39 PM
  4. Highlight Active Row macro, and Bold the Active Cell
    By StudentTeacher in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-08-2013, 07:43 PM
  5. [SOLVED] How to highlight an active row within a selected range in excel
    By jjin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-05-2013, 08:52 PM
  6. highlight the active row in a range
    By haplo39 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2007, 06:30 AM
  7. [SOLVED] Highlight active range?
    By Gordon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-18-2005, 01:55 PM

Tags for this Thread

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