What do you want to save?
Add Code snippet
New code examples in category VBA
-
Awgiedawgie 2022-03-19 14:25:22
vba string
Dim text1 As String text1 = "Hello" text1 = text1 & " World" Debug.Print Left(text1, 3) ' Hel Debug.Print Right(text1, 4) ' orld Debug.Print Mid(text1, 2, 3) ' ell Debug.Print Len(text1) ' 11 (size) Debug.Print Instr(text1... Add solution -
Awgiedawgie 2022-03-17 18:05:25
excel vba determine number of elements in an array
'Since VBA arrays can have ANY integer value (from -2147483648 to '2147483647) for the lower index in the range for a rank, 'the only sure fire way to determine how many elements is in the array 'is to calculate the value: MsgBox UBound(Arr) - LBound(Ar... Add solution -
A-312 2022-03-17 00:20:14
vb window.minimize
FormBorderStyle = Windows.Forms.FormBorderStyle.None Add solution -
Awgiedawgie 2022-03-16 19:45:23
vba delete array element
Public Sub DeleteElementFromArray(ByRef pArray As Variant, ByVal pIndex As Long) Dim index As Integer If pIndex >= LBound(pArray) And pIndex <= UBound(pArray) Then For index = pIndex + 1 To UBound(pArray) pArray(index - 1... Add solution -
Awgiedawgie 2022-03-16 11:35:05
vba registry settings
' Place some settings in the registry. SaveSetting appname := "MyApp", section := "Startup", _ key := "Top", setting := 75 SaveSetting "MyApp", "Startup", "Left", 50 ' Remove section and all... Add solution
Best helpers
Vlk
+5
Boehmi
+5
Rpeinhardt
+5
Hrishioa
+5
Erwin
+5
Rednryt
+5
Sultan
+5
Bill Reason
+5
Akash Patel
+5
Volker Kamin
+5
Dr.khan
+5