+ Reply to Thread
Results 1 to 4 of 4

Format a range (table row) based on the value in one of its cells right after the editing

  1. #1
    Registered User
    Join Date
    07-17-2017
    Location
    Kazakhstan
    MS-Off Ver
    office professional plus 2010
    Posts
    3

    Format a range (table row) based on the value in one of its cells right after the editing

    Hi everyone,
    I'm very new to VBA and may question may seem very simple. But nevertheless i'm kind of stuck with the task.

    I have a table where in one of its columns is a drop down list. I want VBA to shade out the whole row of the table when one of the values has been chosed from the list.

    I made code to format the row:

    Please Login or Register  to view this content.
    what I need now is to develope code, that would run the code above as soon as the value in any cell of the table column F is set to one of the drop down list values.

    I know that I must place such procedure in Sheet object of the VBA object model, to get VBA react to the change.

    Could you please suggest something.?

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: Format a range (table row) based on the value in one of its cells right after the edit

    without an example file, it seems that conditional formating , is much more straightforward than the vba code. why not post a scaled down example file

  3. #3
    Registered User
    Join Date
    07-17-2017
    Location
    Kazakhstan
    MS-Off Ver
    office professional plus 2010
    Posts
    3

    Re: Format a range (table row) based on the value in one of its cells right after the edit

    Thanks, I also though of conditional formatting, but wanted to realize that using a VBA procedure. It seemed a simple task.

    herein I attach the file. the column where i intend to enter values initiating the formatting code is F.
    Attached Files Attached Files
    Last edited by ilya Excel Forum; 07-18-2017 at 08:57 AM. Reason: checking if the attaching is successfuell

  4. #4
    Registered User
    Join Date
    07-17-2017
    Location
    Kazakhstan
    MS-Off Ver
    office professional plus 2010
    Posts
    3

    Re: Format a range (table row) based on the value in one of its cells right after the edit

    Bump no response

+ 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. VBA - Show cell comments for a specific range of cells based on date, in a table format
    By celebwen_orn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-15-2016, 02:10 PM
  2. Format a cell based on a range of cells
    By kdoug13 in forum Excel General
    Replies: 1
    Last Post: 06-22-2016, 05:58 PM
  3. editing format in a table
    By fight2 in forum Excel General
    Replies: 0
    Last Post: 02-09-2015, 02:22 PM
  4. Replies: 3
    Last Post: 09-13-2012, 03:25 AM
  5. [SOLVED] Conditional Format column based on value of a range of cells.
    By pauld.ccvw in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-27-2012, 09:35 AM
  6. [SOLVED] Conditional Format cell based on value of cells in range
    By Dean81 in forum Excel General
    Replies: 5
    Last Post: 03-20-2012, 12:20 PM
  7. how do i format a cell based on format of a range of cells?
    By Chris Hardick in forum Excel General
    Replies: 2
    Last Post: 04-03-2006, 03:55 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