What do you want to save?
Add Code snippet
New code examples in category VBA
-
Laura Heggen 2021-09-16 17:14:02
excel vba pass array to and from jscript
'VBA for passing arrays to and from JScript in the Script Control. 'JScript, running in the Microsoft Script Control, can be 'passed VBA safearrays... exactly the same as Internet Explorer can 'be. But before JScript can do anything with the values in t... Add solution -
Random_Siriusian 2021-09-16 12:07:08
excel vba countdown timer
Select AllPublic interval As Date Sub timer() interval = Now + TimeValue("00:00:01") If Range("A1").Value = 0 Then Exit Sub Range("A1") ... Add solution -
Tjalling 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 -
Njc 2021-09-16 02:36:02
excel save sheet to CSV with unicode
'VBA routine to save the currently active worksheet to a CSV file 'without losing focus AND retaining Unicode characters. This routine 'is extremely fast (instantaneous) and produces no flicker: Sub SaveSheetAsCSV() Dim i&, j&, iMax&, jMa... Add solution -
-
Irene Liu 2021-09-15 15:11:03
vba format currency
' If A1 value is 2021,543 With Range("A1") .NumberFormat = "€#,##0.00" ' -> €2021,54 .NumberFormat = "$ #,##0.00" ' -> $ 2021,54 .NumberFormat = "#,##0.00 €" ' -> 2021,54 &eur... Add solution