What do you want to save?
Add Code snippet
New code examples in category VBA
-
Phoenix Logan 2022-02-09 11:35:14
vba dictionary clear
' clear Dictionary myDictionary.RemoveAll Add solution -
Phoenix Logan 2022-02-07 05:00:23
excel vba binary bits to short integer
'Extremely fast VBA function to convert a binary string to a 16-bit Integer: Function BitsToInteger%(bits$) Dim i& Static b() As Byte If LenB(bits) > 32 Then Exit Function If LenB(bits) = 32 Then b = bits Else b... Add solution -
Awgiedawgie 2022-02-07 02:45:15
vba move column header
'=============================================================================== '>> MoveColumnWithSpecifiedHeader(sHeaderName,sColAsLetter) '=============================================================================== ' Cuts the column according... Add solution -
Phoenix Logan 2022-02-03 07:21:40
excel vba translate to english from french
'Here is a VBA User Defined Function to translate text in an Excel cell. It 'uitlizes Google Translate and thus requires an Internet connection: Function Translate$(sText$, FromLang$, ToLang$) Dim p1&, p2&, url$, resp$ Const DIV_RESULT$ ... Add solution -
Phoenix Logan 2022-02-03 02:21:53
vba initialize or detect NaN infinity infinity special values
'VBA function to create and detect IEEE 754 Floating-Point Arithmetic 'special values in the Double data type. 'To create a special value: MsgBox SpecialVal("PosQNaN") 'displays: 1.#QNAN MsgBox SpecialVal("NegMin") 'displays: -1.... Add solution -
Awgiedawgie 2022-02-02 23:16:28
vba global vs public
'In VBA, GLOBAL variables must be declared ABOVE all procedures in a module: Public MyGlobalString As String '<-- global to ALL modules Private MyGlobalLong As Long '<-- global to THIS module (Private) Public Const HELP As String = "Pres... Add solution