View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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