+ Reply to Thread
Results 1 to 5 of 5

Highlight the cell when macro is run

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Highlight the cell when macro is run

    Hello:

    Please refer to attached file.
    I have Macro button (currently does not have any code) as shown Button 1 and Button 2.
    I need the cell A4 highlighted Green when Button 1 is pressed and Cell A5 highlighted Green when Button 2 is pressed.
    I would need a VB Code (Clear button)to clear the highlighted cells at the start.

    Let me know if you have any questions.
    Thanks.

    Riz
    Attached Files Attached Files

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Highlight the cell when macro is run

    Hi, riz,

    try
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Highlight the cell when macro is run

    This would work as well, whichever you prefer...
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  4. #4
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Highlight the cell when macro is run

    Hi Hahobe:

    Your solution will work great for me.
    Thanks a lot both.
    Riz

  5. #5
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Highlight the cell when macro is run

    Sorry, I forgot about clearing the cells at the start.
    Thank you for the rep
    Last edited by gmr4evr1; 01-11-2015 at 11:50 AM. Reason: added a TY

+ 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 cell with macro
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 38
    Last Post: 07-09-2013, 03:32 PM
  2. [SOLVED] Highlight Cell If Macro
    By ScabbyDog in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-31-2013, 04:41 PM
  3. Macro to search and highlight a cell prior to the searched cell
    By gjccks in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-15-2013, 01:51 PM
  4. [SOLVED] Macro to highlight a cell if greater
    By ISUCyclones in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-06-2012, 04:17 PM
  5. Macro Help:highlight any cell
    By Celt in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 03-16-2006, 06:54 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