Posts by backgroundbook

    I have found a part solution (placed in the ThisWorkbook module):


    However, I would want this to only look in 3 named ranges instead of the whole sheet, and to add a comment inside the changed cell instead of a message box, something like this:


    Code
    1. Target.ClearComments
    2. Target.AddComment.Text Text:= preValue & Chr(10) &
    3. Format(Date, "mm-dd-yyyy") & Environ("UserName")

    I have data that looks like this: CI-1, CK-08, H-03, J-12, CM-11, B-8

    I want all the numerical characters from 1 to 9 to have 0s before them with the letters unchanged.

    ActualResult
    CI-1CI-01
    CK-08CK-08
    H-03H-03
    B-8B-08

    I am able to do this through several separated formulas (step by step; separating the letters from the numbers, adding the leading 0, concatenating them back together) however, this is taking too long to compute.

    Everytime a cell changes in a named range, I want the code to clear existing comments, then record the old value as a new comment. I have to use Worksheet_Calculate because the cell changes based on a formula. I have tried several, methods, but none are working...

    In this case, it adds a comment to every cell.

    This works only when I change the cell manually.