+ Reply to Thread
Results 1 to 4 of 4

How to highlight selected row and column via find facility

  1. #1
    Registered User
    Join Date
    09-13-2015
    Location
    Izmir
    MS-Off Ver
    2016
    Posts
    2

    How to highlight selected row and column via find facility

    Hello everyone,

    I have a data sheet which has 1500 rows and 7 columns. So I need to highlight selected row and column when hit the find facility in order to prevent miscalculation.

    Can you please help me.

    Thank you
    Last edited by hanamichi sakuragi; 09-16-2015 at 05:27 AM.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: How to highlight selected row and column via find facility

    Hi there,

    The following code will do what you want provided that your data range does not contain any cells which have coloured backgrounds:

    Please Login or Register  to view this content.

    The highlighted values can be altered to suit your own requirements.

    The above code highlights only the part of the row/column which is contained within the data range - it can easily be adapted to highlight the entire row/column if required.

    If any of the cells in your data range have coloured backgrounds, the code will become significantly more complicated.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

  3. #3
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: How to highlight selected row and column via find facility

    Hi again,

    Thanks for your private message regarding the above.

    The attached workbook incorporates the code from my previous post, and is inserted in the VBA CodeModule for the "Highlight" worksheet. To view the code in the CodeModule just right-click on the worksheet tab ("Highlight") and select "View Code" from the dropdown list.

    This code applies only to the "Highlight" worksheet - if you want this feature to be available for another worksheet you must copy the code into the VBA CodeModule for that worksheet.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M
    Attached Files Attached Files

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: How to highlight selected row and column via find facility

    Hi again,

    Many thanks for your private message.

    You're very welcome - glad I was able to help.

    Regards,

    Greg M

+ 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. Highlight Selected Cell When Using FIND
    By smlaff01 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 03-10-2016, 02:53 PM
  2. [SOLVED] Ability to auto-highlight entire row and column of selected cell
    By stephenminton in forum Excel General
    Replies: 22
    Last Post: 04-02-2014, 02:35 PM
  3. Defining a range to highlight column and row in line with selected cell
    By ACM2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2012, 11:13 PM
  4. highlight duplicates in column when selected
    By Doug W in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2011, 10:43 AM
  5. Find Facility - On_Click
    By thompsy121 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-09-2008, 07:35 AM
  6. Replies: 7
    Last Post: 02-27-2008, 03:53 PM
  7. Replies: 1
    Last Post: 05-22-2006, 05:10 AM
  8. [SOLVED] How to highlight row and column of the selected cell
    By Row_Column_Highlight in forum Excel General
    Replies: 2
    Last Post: 02-27-2005, 07:06 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