Excel tip custom user defined functions VBA

Learn how to make a custom user defined function in Excel for when Excel doesn't have what you need.

Function GetNumeric(CellRef As String) as Long
Dim StringLength As Integer
StringLength = Len(CellRef)
For i = 1 To StringLength
If IsNumeric(Mid(CellRef, i, 1)) Then Result = Result & Mid(CellRef, i, 1)
Next i
GetNumeric = Result
End Function

#excel #exceltips #exceltricks

[lizard]

How can you encrypt an Excel file with VBA? Encryption cannot be skipped, such as archiving it or changing the file extension format .