Excell cell formatting
Put the following in Worksheet code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("B9")) Is Nothing Then
Else
If IsEmpty(Target) Then
Target.Value = "-"
End If
End If
End Sub
It sets up cell B9. Just expand the Intersect to include as many cells as
you need.
REMEMBER: worksheet code.
--
Gary's Student
"Matt Hannan" wrote:
I would like a selection of cells to display "-" unless text or a number is
typed in. However, if the text / number is subsequently deleted, I would like
the cell to revert back to "-".
Almost like the default content for the cell is "-" and not blank / empty
|