Skip to content

Instantly share code, notes, and snippets.

@yamadamael

yamadamael/stringformat.vba

Created September 5, 2020 03:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yamadamael/1235736e7e1912bde04bf734c8a5b360 to your computer and use it in GitHub Desktop.
Save yamadamael/1235736e7e1912bde04bf734c8a5b360 to your computer and use it in GitHub Desktop.
Download ZIP
stringformat.vba
Raw
stringformat.vba
Function StringFormat(format As String, ParamArray params() As Variant)
Dim find As String
StringFormat = format
For i = 0 To UBound(params)
find = "{" & i & "}"
StringFormat = Replace(StringFormat, find, params(i))
Next i
End Function
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment