What do you want to save?
Add Code snippet
New code examples
-
VBA 2022-01-22 14:55:20
excel vba date to unix timestamp and vice versa
'VBA functions to convert between Excel and Unix date-times. 'These work on Windows and optionally the Mac: Function UnixDateTime#(ExcelDateTime As Date, Optional Mac As Boolean) Dim OSOffset: OSOffset = IIf(Mac, 24107, 25569) UnixDateTime = (Ex... Add solution -
VBA 2021-11-18 01:12:19
xl-vba how to return result from a function
'In VBA, you assign the return value to the name of the function. 'This is different from many languages that use the 'return' keyword: Function Yesterday() As Date Yesterday = Date() - 1 End Function 'VBA functions can be called from other VBA code: ... Add solution -
VBA 2021-11-17 20:39:12
excel VBA return a result function
'In VBA, you assign the return value to the name of the function. 'This is different from many languages that use the 'return' keyword: Function Yesterday() As Date Yesterday = Date() - 1 End Function 'VBA functions can be called from other VBA code: ... Add solution -
VBA 2021-11-15 18:35:19
excel vba count instances of substring
'VBA functions to count the occurrnces of a substring in a string. 'Choose your function flavor: 'Small and Slow: Function InStrCount&(s1$, s2$, Optional Compare As VbCompareMethod = vbBinaryCompare) If Len(s1) Then If Len(s2) Then InStrCount = ... Add solution -
VBA 2021-11-06 13:20:24
excelvba return a result from a function
'In VBA, you assign the return value to the name of the function. 'This is different from many languages that use the 'return' keyword: Function Yesterday() As Date Yesterday = Date() - 1 End Function 'VBA functions can be called from other VBA code: ... Add solution -
VBA 2021-10-30 01:48:03
excel how to return a result from a VBA function
'In VBA, you assign the return value to the name of the function. 'This is different from many languages that use the 'return' keyword: Function Yesterday() As Date Yesterday = Date() - 1 End Function 'VBA functions can be called from other VBA code: ... Add solution -
VBA 2021-10-15 06:50:04
excel date to unix timestamp
'VBA functions to convert between Excel and Unix date-times. 'These work on Windows and optionally the Mac: Function UnixDateTime#(ExcelDateTime As Date, Optional Mac As Boolean) Dim OSOffset: OSOffset = IIf(Mac, 24107, 25569) UnixDateTime = (Ex... Add solution -
VBA 2021-10-02 01:04:02
excel vba count substring in string
'VBA functions to count the occurrnces of a substring in a string. 'Choose your function flavor: 'Small and Slow: Function InStrCount&(s1$, s2$, Optional Compare As VbCompareMethod = vbBinaryCompare) If Len(s1) Then If Len(s2) Then InStrCount = ... Add solution -
VBA 2021-09-16 10:23:02
xl-vba return a result from a function
'In VBA, you assign the return value to the name of the function. 'This is different from many languages that use the 'return' keyword: Function Yesterday() As Date Yesterday = Date() - 1 End Function 'VBA functions can be called from other VBA code: ... Add solution
Best helpers
+5
+5
+5
+5
+5
+5
+5
+5