Conditionally Fill Cell With Text

Originally Posted by Freezerburn

Is it possible...to have a cell contain a formula in which the value within the cell is automatically something if nothing else was manually entered in that specific cell?

For example, I would want a certain cell to always be "--" if no other value was entered in on the data form. Is there a specific formula/function for this? Perhaps some type of if statement?

Hi,

One way is to type '-- into the cell, then when you type a figure in that will be overwritten.

hth
---

Originally Posted by Freezerburn

That is what I currently am doing, but new rows are inserted into the sheet very often so they don't come "pre-loaded" with the double dash in the cell. I don't think what I asked originally is possible. Thanks anyways!

Hi,

to cover the insertd single row, or inserted multiple rows, and put '-- in column A of such rows, then on the sheet tab, Rightmouse and select View Code, and paste this code into the sheet displayed.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rw As Range
For Each rw In Target.Rows
    With Cells(rw.Row, 1)
    If .Value = "" Then
        .Value = "'--"
        End If
        End With
Next
End Sub

If the column is not A, then change the red number to the number that represents the column (do =Column() in a cell of that column to confirm).

Let me know how you go
---