Results 1 to 8 of 8

Help 'freezing' value of formulas when date becomes 'today'.

Threaded View

  1. #1
    Forum Contributor Big.Moe's Avatar
    Join Date
    03-15-2012
    Location
    Corea, Maine, USA
    MS-Off Ver
    Excel 2010
    Posts
    262

    Help 'freezing' value of formulas when date becomes 'today'.

    Hello,

    I already have this handy code that 'freezes' the current value of a formula when there is activity in the cell adjacent.
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Cells(10, Target.Column) Like "PRICE*" Then
    If Target.Offset(, 1).HasFormula And Target.Row > 9 Then
        Target.Offset(, 1).Value = Target.Offset(, 1).Value
    End If: End If
    End Sub
    Now I would like to do a similar process for the "Item Description" column. This time I would like the formula values to 'freeze' when the associated date for that day becomes the current date.

    Freeze Column.jpg

    Regretfully, the column letter always changes, and the date cell always changes. However, they always have the same juxtaposition (see attached file of typical month sheet below). Sorry, could not upload whole workbook due to size constraints.

    My VBA skills are next to nothing, but this is the general direction of what I think the code should look like:
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Cells(38, Target.Column) Like "ITEM*" Then
    If Target.Offset(38,10) {DATE = TODAY} Then
        {Column B formulas freeze to current values}
    End If: End If
    End Sub
    Thanks for reviewing my post and hopefully I've clearly described the problem at hand. Not always the easiest task to master.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 09-06-2023, 08:19 PM
  2. [SOLVED] Sumif from date (Today or greater than today) to last date
    By thilag in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-23-2015, 03:53 AM
  3. Replies: 6
    Last Post: 08-08-2011, 08:32 AM
  4. Freezing and unfreezing formulas
    By john dalton in forum Excel General
    Replies: 0
    Last Post: 07-29-2011, 09:04 AM
  5. Freezing Formulas
    By vinid in forum Excel General
    Replies: 2
    Last Post: 04-13-2011, 11:11 PM
  6. Freezing Cell Formulas
    By fourgreatpoints in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-28-2008, 03:16 PM
  7. freezing formulas
    By junoon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2006, 08:35 AM

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