+ Reply to Thread
Results 1 to 5 of 5

Max value in cell - overflow into adjacent cell

  1. #1
    Registered User
    Join Date
    03-23-2014
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    8

    Max value in cell - overflow into adjacent cell

    I want to have a field that maxes out at 2400 minutes (40 hours) and then filters the overflow into another cell.

    I found this solution in another thread (post5560206), but for some reason I can't get the code to run properly (at all). Nothing changes when I enter a number to the minutes column on the user sheet.

    Can someone maybe take a look at this and see if they can identify how I am misapplying the code? I suspect it has to do with the formula in D2, but I don't know. Not sure how I can work around that...

    Here's how I have it set up: (test file attached)

    HTML Code: 
    Attached Files Attached Files

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,881

    Re: Max value in cell - overflow into adjacent cell

    The 'Target' in a Worksheet_Change event is the cell address of the cell you manually changed (or via code), not one that changes via formula/calculation. So in this case, the Target.Address would never be D2 as you're only changing cells starting in row 5 (or on other worksheets).

    You would likely need to use the Worksheet_Calculate event, and adjust the code to check the value in 'Test User'!D2 upon each calculation attempt.

  3. #3
    Registered User
    Join Date
    03-23-2014
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    8

    Re: Max value in cell - overflow into adjacent cell

    Thanks, I'll see if I can wrangle that.

  4. #4
    Registered User
    Join Date
    03-23-2014
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    8

    Re: Max value in cell - overflow into adjacent cell

    Nope, that didn't work. Trying to get creative here, but not seeing a path forward. I can get it to work on manually entered fields, just not on a calculated field, which you said, of course.

    The crux of the project lies in being able check the completed time vs the goal time - and not factor extra time into the reporting numbers. I can continue to do it manually, but it gets a little tedious.
    Last edited by mdwbeex; 08-25-2021 at 05:25 PM.

  5. #5
    Registered User
    Join Date
    03-23-2014
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    8

    Re: Max value in cell - overflow into adjacent cell

    Anyone have any thoughts on how to make this happen?

+ 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] Cell with Number - Left align & overflow to adjacent cells
    By Un-Do Re-Do in forum Excel General
    Replies: 21
    Last Post: 06-24-2021, 05:27 AM
  2. [SOLVED] Cell text overflow to adjacent cell
    By Axmed.cm in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 03-31-2018, 03:51 AM
  3. Replies: 2
    Last Post: 09-19-2017, 08:05 AM
  4. Replies: 4
    Last Post: 04-18-2017, 07:09 AM
  5. Replies: 3
    Last Post: 07-21-2015, 05:10 PM
  6. [SOLVED] Date Field Overflow Into Adjacent Cell
    By CrocHntr in forum Excel General
    Replies: 3
    Last Post: 03-20-2014, 01:36 PM
  7. Preventing cell overflow into next cell (Solution)
    By bigtheta in forum Excel General
    Replies: 2
    Last Post: 02-23-2012, 03:07 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