format output memorysize
3
mySizeMemory:this function just formats the output the way I like Input integer in Bytes, outputs easily human readable format
Function mySizeMemory(integerSize)
If integerSize >= 1000000000 Then
mySizeMemory = Round(integerSize / 1047000000, 1)
mySizeMemory = mySizeMemory & " GB"
ElseIf ((1000000000 > integerSize) And (integerSize >= 1000000)) Then
mySizeMemory = Int(integerSize / 1047000)
mySizeMemory = mySizeMemory & " MB"
ElseIf ((1000000 > integerSize) And (integerSize >= 1000)) Then
mySizeMemory = Int(integerSize / 1024)
mySizeMemory = mySizeMemory & " KB"
Else
mySizeMemory = integerSize & " Bytes"
End If
End Function






There are currently no comments for this snippet.