Simple add Format Numeric value in Function

Hi guys,

I need some help adding a line to my Function that will Format the numeric field as follows: "#,##0.00"

My function code:

'FUNCTION
Function IsInvalid(ctl As MSForms.Control) As Boolean

    If Len(ctl.Value) = 0 Then
        MsgBox "Please enter a value"
        IsInvalid = True
        
    ElseIf Not IsNumeric(ctl.Value) Then
        MsgBox "Sorry, only numbers allowed"
        ctl.Value = vbNullString

        IsInvalid = True
      
    End If

End Function


Private Sub txtConsumables1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Cancel = IsInvalid(txtConsumables1)
End Sub

Thank you!

I don't get this anyway because your formula returns a boolean, not a number?

To clarify, you can format the number returned by a function. I just tried that. But why not just format the cells separately?

Have you tried that? I don't see why that wouldn't work. To do for lots of textboxes you would need a class module, but unfortunately I don't think that's possible for the Exit event.