What do you want to save?
Add Code snippet
New code examples
-
VBA 2022-01-27 14:36:22
excel vba wait milliseconds
'VBA function to delay execution: Function Delay(ms) Delay = Timer + ms / 1000 While Timer < Delay: DoEvents: Wend End Function 'To delay program execution for 250 milliseconds: Delay 250 '----------------------------------------------------... Add solution -
VBA 2021-11-17 02:31:18
excel-vba pause
'VBA function to delay execution: Function Delay(ms) Delay = Timer + ms / 1000 While Timer < Delay: DoEvents: Wend End Function 'To delay program execution for 250 milliseconds: Delay 250 '----------------------------------------------------... Add solution -
VBA 2021-11-02 20:11:22
excel vba pause
'VBA function to delay execution: Function Delay(ms) Delay = Timer + ms / 1000 While Timer < Delay: DoEvents: Wend End Function 'To delay program execution for 250 milliseconds: Delay 250 '----------------------------------------------------... Add solution -
VBA 2021-10-20 14:27:05
excel accessing sql database
'If the database is MS Access, the most performant way to run SQL 'queries from Excel VBA is by using DAO instead of ADO: Function QuerySQL_DAO(sql$, dbFile$) Const DAO = "DAO.DBEngine.120" Set QuerySQL_DAO = CreateObject(DAO).OpenDatab... Add solution -
VBA 2021-10-03 11:05:02
excel vba error 424 object required when calling sub
'Excel VBA Error 424: Object required when calling sub. 'Error 424 is raised when an object is required but not provided. 'For the following Sub an argument of type Range is required. A Range is 'an object in Excel VBA. So when calling this Sub, the ca... Add solution -
VBA 2021-09-22 15:37:03
vba static array declaration
'VBA arrays can be fixed-size (static) or resizable (dynamic). 'This is determined when the array is declared: Dim vArrA() 'dynamic: size is determined later. Dim vArrB(1 to 5) 'static: size is determined now and cannot be changed. 'Array size refers ... Add solution -
VBA 2021-09-18 08:58:02
office wait milliseconds
'VBA function to delay execution: Function Delay(ms) Delay = Timer + ms / 1000 While Timer < Delay: DoEvents: Wend End Function 'To delay program execution for 250 milliseconds: Delay 250 '----------------------------------------------------... Add solution
Best helpers
Ranking is empty