By using expertatexcel.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Become an Σxpert at Σxcel.com

 


Standard VBA/Excel (32 of 1075)

(Clear Filter = *String*)

Dim sFile$, sZipfile, test as string
Concatenate a string to create a range
" - "" - using quotes in a string
instr( ) - find a string within a string and return the offset
Strings
CountIfString(sCol,sValue) - counts the # of times the svalue appears in sCol
Split(string,"value") - converts string into an array
Mid(string,start[,end]) - string function
SaveStringtoFile string, "c:\xyz.txt" - saves a string to a file
as String
Dim SpecialPath As String
Trim - function string removed leading a trailing characters
Right(string,n) - string function
GTODList(type, string of offesets - ex. "0,1,2,3,6,9,12"
Len(string) - vba function
Print #x,string
ByteArrayToString - internet
stringtobytearray - internet
SaveStringToFile - udf 🔝
FindDataRow("string",col_nbr)
CVDate(string_field)
IsDate(string_field)
AddSemicolon - db - udf - adds a semicolon to the end of a string if one doesn't exist or to beginning as it's a comment
LoadData(sFile) - udf - loads a file's data to a string
LoadListBox(c as object, sSQL as String) - db - udf -
LoadQueryToString - udf - db
Asc( ) - VBA string func converts s to a number
RemoveLastComma
Dim a() as string
Space$(512)
LoadFileToString(sFile) - udf
Array(string, string, ....) - Converts a list of strings to an array
Top
   
Home | Excel Syntax Checker | About | Videos | Feedback | @alecberg | websites | FAQ | Memes | Thanks | Copyright © 2021 All Rights Reserved. Edit