+ Reply to Thread
Results 1 to 3 of 3

How To and What... code to enter into VisuaBasic Module to highlight active row/column '07

  1. #1
    Registered User
    Join Date
    03-20-2014
    Location
    4863243
    MS-Off Ver
    Excel 2007
    Posts
    2

    Red face How To and What... code to enter into VisuaBasic Module to highlight active row/column '07

    Good Afternoon! I am working on Excel 2007... and I have approximately 2,000+ rows of data. I've been looking around for a way to have the row/column highlighted yellow of the cell I'm currently typing in... and then when I move on to the next highlight those and return the previous cells to the way they were before and highlight the new row/column of the cell selected highlighted yellow. I am not necessarily an excel novice however I've not ever used Visual Basic and am having a hard time getting other codes I've found via my search to run properly. Does anyone have a code I could use? ... and along with that tips/steps on how to get it to run?

    SO MANY THANKS IN ADVANCE!!

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,335

    Re: How To and What... code to enter into VisuaBasic Module to highlight active row/column

    Welcome to the forum.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Registered User
    Join Date
    03-20-2014
    Location
    4863243
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How To and What... code to enter into VisuaBasic Module to highlight active row/column

    Thanks!

+ 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. Replies: 0
    Last Post: 03-08-2014, 08:02 AM
  2. [SOLVED] Highlight Active Row and Column.
    By yatin1964 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-14-2013, 06:47 AM
  3. Excel 2007 : To highlight active row and column
    By r1jender in forum Excel General
    Replies: 5
    Last Post: 02-29-2012, 03:12 AM
  4. Using code to highlight active row. Can I toggle on/off on the fly?
    By Pete123abc in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-08-2011, 01:34 PM
  5. [SOLVED] How to highlight active row and column?
    By rjamison in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2005, 02:05 AM

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