Is this possible???

[joy_666]

Hi,

I want to put a default value in column C, say from C2-C100.

I want the default value as 0.00.

What I want is that it should let the user key in any value greater than 0.00 but shouldn't let the user leave the cell as blank.(shouldn't let the user to delete the 0.00)

Is this possible?????

I have used all the options in validation but it doesn't help.......

Any suggestions?!?!??

 

[Sal Paradise]

Create a template with C2:C100 filled with the format/number you want (in this case Number with 2 decimal points, and 0.00), and then set cell validation to require a number. Save that as a template, and presto!

 

[GTO]

Greetings Joy,

This is a worksheet event, so must be stored in the sheet's module.

Right-Click the tab of the sheet you want this in, and select View Code.

Paste code in VBIDE.

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rCell As Range
    '// Identify the range that we want to alter what's being changed.      //
    If Not Application.Intersect(Range("C2:C100"), Target) Is Nothing Then
        '// Optional: to insist on number format
        Target.NumberFormat = "0.00"
 
        '// If just one cell is being changed...                            //
        If Not Target.Count > 1 Then
            If Target.Value = vbNullString Then
                Target.Value = 0
            End If
        '// Else if a bunch o' cells are changing.                          //
        Else
            For Each rCell In Target
                If rCell.Value = vbNullString Then
                    rCell.Value = 0
                End If
            Next
        End If
    End If
End Sub

Hope this helps,

Mark

 

[joy_666]

Bullz Eye!!!!!!!


Thanks you so much GTO !!!!!