What do you want to save?
Add Code snippet
New code examples in category VBA
-
-
A-312 2022-05-13 15:16:29
excel vba set cell format to date
'In Excel, dates are actually just numbers that have a special 'formatting applied to display like dates. 'VBA code to change the Number Formatting of a cell range: [A1].NumberFormat = "mm-dd-yyyy" 'There are hundreds of options for Number Fo... Add solution -
Awgiedawgie 2022-05-13 11:06:39
vba ado ace sql alias ignored for calculated column
'For a field alias to work and appear as a column name in the recordset 'the ENTIRE calculation MAY NEED TO BE held within PARENTHESES: SQL = "SELECT ((age + fare) / 2) as [Nonsense] from Titanic" Add solution -
Awgiedawgie 2022-05-13 10:36:15
excel vba generate guid uuid
'Native and fast VBA function to create a GUID / UUID 'that does not rely upon Scriptlet.TypeLib or any external library. 'Call the function like so: MsgBox GUID Function GUID$(Optional lowercase As Boolean, Optional parens As Boolean) Dim k&... Add solution -
Phoenix Logan 2022-05-13 10:06:06
office vba like
'VBA's Like operator can be used to determine if 'one string is contained in another: MsgBox "Excel Hero" Like "*Hero" 'Displays: True 'Notice that 'Find' supports wild card characters. 'Full documentation: ' https://docs.micro... Add solution -
Awgiedawgie 2022-03-27 20:55:02
excel vba check if all substrings in list are in string
'VBA function to check if ALL of a list of substrings is contained 'within a string: Function AllIn(s$, ParamArray checks()) As Boolean Dim e For Each e In checks If 0 = InStrB(s, e) Then Exit Function Next AllIn = True End Functi... Add solution
Best helpers
Ranking is empty