+ Reply to Thread
Results 1 to 6 of 6

Change a cell value when a cell range is modified

  1. #1
    Registered User
    Join Date
    03-07-2015
    Location
    Ontario, Canada
    MS-Off Ver
    Office 2007
    Posts
    3

    Change a cell value when a cell range is modified

    Hi All,

    I have a VBA program that runs through excel. The program takes information from a vba form stores it to a database with a copy on a row in an excel sheet. When data from that row is modified I need a cell on that row to mark the row for updating.

    I've attached a sample of the sheet layout.

    Row.jpg

    If Items/Cost/Retail changes the Sync Row needs to be updated to Yes.

    Any insight is appreciated.

    Thank you!
    Attached Images Attached Images
    Last edited by jay_610; 03-07-2015 at 11:31 AM.

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Change a cell value when a cell range is modified

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-07-2015
    Location
    Ontario, Canada
    MS-Off Ver
    Office 2007
    Posts
    3

    Re: Change a cell value when a cell range is modified

    How can this be linked to the excel sheet?

  4. #4
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Change a cell value when a cell range is modified

    1. Press Alt+F11 to open the VBA editor.
    2. On the left hand side of the editor is the Project explorer.
    3. Find your workbook name, then expand the Object folder to view the sheet objects.
    4. Double click the sheet name that you want the code to run on (Sheet1 or whatever).
    5. Paste the code in the white space to the right.
    6. The code will now run automatically. You don't need to keep the VBA editor window open.

  5. #5
    Registered User
    Join Date
    03-07-2015
    Location
    Ontario, Canada
    MS-Off Ver
    Office 2007
    Posts
    3

    Re: Change a cell value when a cell range is modified

    That's awesome! Thanks Bro!

  6. #6
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Change a cell value when a cell range is modified

    Glad to help! Please mark this thread as SOLVED (instructions below). And any reputation points (the star in the lower left of my posts) is appreciated.

    To mark solved:
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

+ 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. Clear cell range on multiple sheets if cell on one sheet is modified.
    By bjg1016 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-12-2012, 02:39 PM
  2. Display date in a cell when cell range or colum is modified
    By dr mint in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-27-2012, 08:54 PM
  3. Display Message Box if any cell value in range is modified
    By eddieD95 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-16-2012, 10:31 AM
  4. When cell is modified Hide Entire Rows in a Range
    By Hudas in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-09-2012, 09:43 AM
  5. [SOLVED] If a cell is modified after a date; font color change indicate
    By jcampbell@wyndham.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-15-2005, 04:10 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