Forum Discussion
Cell that auto fills by if statement or allows manual input
The functional programming style of an Excel sheet formula is intended to prevent the reassignment of a new value to a cell such as you describe. On the other hand. an imperative programming language such as VBA is allowed to make such state changes. Hence HansVogelaar 's solution.
There is a trick that may achieve the effect you require without resorting to VBA. If you insert a new column D then a formula there can be made to display in column B, provided the cell in column B is blank. The default text in column D/C is heavily indented and right aligned in order to move it left into the adjacent cell.
The functional programming style of an Excel sheet formula is intended to prevent the reassignment of a new value to a cell such as you describe. On the other hand. an imperative programming language such as VBA is allowed to make such state changes. Hence HansVogelaar 's solution.
There is a trick that may achieve the effect you require without resorting to VBA. If you insert a new column D then a formula there can be made to display in column B, provided the cell in column B is blank. The default text in column D/C is heavily indented and right aligned in order to move it left into the adjacent cell.
