+ Reply to Thread
Results 1 to 5 of 5

highlight rows from inputbox

  1. #1
    Forum Contributor
    Join Date
    11-21-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    190

    highlight rows from inputbox

    Hi,
    I want to highlight rows from input box.
    If inputbox got 6,68,112 then, I want to highlight the column B in these rows in sheet1.

    Below is my code to start.

    Please Login or Register  to view this content.
    After this code, what should I do to complete?

    Thanks in advance.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,444

    Re: highlight rows from inputbox

    Does this help?

    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,821

    Re: highlight rows from inputbox

    Maybe:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  4. #4
    Forum Contributor
    Join Date
    11-21-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    190

    Re: highlight rows from inputbox

    Thank you so much.
    It worked!

  5. #5
    Forum Contributor
    Join Date
    11-21-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    190

    Re: highlight rows from inputbox

    Thanks! It worked.

+ 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] Copy Down (x) Rows from InputBox Value
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2013, 10:07 AM
  2. How not to highlight Inputbox default Value?
    By Paddy23 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2013, 06:12 AM
  3. Replies: 2
    Last Post: 06-27-2012, 12:27 PM
  4. [SOLVED] highlight/remove highlight of rows conditional on cellvalue
    By timtim89 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2012, 07:14 AM
  5. again problem with inputbox an delete rows
    By babar48 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-15-2011, 08:18 AM
  6. Number of Rows in a InputBox
    By bignowa in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-25-2011, 11:42 PM
  7. InputBox-search through rows in array
    By Moriarti in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2009, 05:48 AM
  8. Delete Rows Using Inputbox
    By japorms in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-08-2008, 05:16 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1