Search code examples
excelformulas

Populating blank cells with a formula in Excel (without VBA)

e.g.

(N.B. All the following actions reference the same cell)

  1. A cell contains a formula to populate the 'default' value of that cell.
  2. The user overwrites the default value.
  3. The user decides to delete the value that they have entered.
  4. The original formula is automatically reinstated to provide the 'default' value again.

Is this possible without VBA, or is there a reasonable work around?

Solution

  • I'm not sure how you plan to do all of that without VBA. I'm not and Excel wizard, but I don't think it can done without VBA. There is some intelligence needed in your procedures that can not (I believe) be performed with simple functions.