listi.net

Listi.net

             


 Contents >


Excel VBA Programming concepts

0. Logic Errors
1. Syntax Errors
2. Range
3. Subroutines
4. Trace
5. Status bar
6. Application Object
7. Global variables
8. Constants
9. Concatenation
10. Variable Naming
11. Excel If function, nest using Or( ) or And( )
12. Data types
13. Sheet functions
14. Comments
15. Rows( ).
16. Columns( ).
17. Hardcoding
18. .select
19. Arrays
20. For - next
21. Autofilter used to filter in Excel VBA
22. Selection
23. Doevents
24. .EntireRow.delete
25. Create Sheet
26. Code will Change
27. Error Handling
28. Optimizing VBA
29. Mod function
30. Call Stack - Ctrl+L
31. Object Browser
32. Protection of sheet
33. Visual Basic Editor Window
34. Cells(r,c)
35. Offset(r,c)
36. Modules
37. Pivot Tables
38. Lastrow = activesheet.usedrange.rows.count
39. Format function
40. Active______________
41. VLookup
42. Autofill
43. Clipboard
44. PasteSpecial
45. EntireColumn.Autofit.row
46. select all cells - cells.select
47. With - End With
48. Saving your code
49. Versioning
50. Copy to clipboard
51. Named Range
52. User Defined Function
53. Addins - XLA
54. Templates - XLT
55. File Suffixes
56. Deleting/Inserting columns
57. Refactoring
58. Modifying Macro Recorder Code
59. Dates
60. Events
61. FindDataCol
62. ColumnLetter
63. Sorting in Excel VBA
64. Find
65. Email
66. Getting Internet Data
67. Database
68. FindHeadingRow
69. Column Variables
70. Converting Parameters to proper type with parenthesis ( )
71. GoTo
72. Do - Loop
73. File Processing
74. References
75. Move active cell one to right = Activecell.offset(0,1).select
76. Shortcut Keys
77. Immediate Window
78. Charts
79. Forms
80. Clearing Data
81. Formatting Data
82. Msgbox
83. Comments on a Cell
84. Excel Functions
85. Absolute vs. Relative Cells
86. Array Functions (Control Shift Enter)
87. Due Date Calcuatlion
88. 'Sheet Name'!RnCn reference
89. Double quotes """""
90. For Each - Next
91. String Functions
92. Dim
93. Testing
94. Continuation Character _
95. Conditional Formatting
96. Design Mode
97. Edit Mode
98. The Ribbon
99. Buttons
100. Hacking
101. Use the Internet
102. F1 Help
103. Finding Recorded Macro
104. Excel Terms
105. Understanding Existing Systems
106. Understanding Complex Excel Formulas
107. Execute Code when Workbook Opens or Closes
108. Shapes
109. Assign a Shortcut Key to a Macro
110. Variables
111. Database Functions (ex. Dcount)
112. SumProduct
113. Hidden Columns and Rows
114. Executing VBA Functions in Excel
115. Executing Excel Functions in VBA
116. If cond then statement else statement end if
117. Error Handling - On Error
118. Excel #Name type errors
119. Windows API
120. Loop over hidden rows
121. Backing up your Work in Excel
122. Random Numbers
123. Statistical Functions
124. Recursion
125. Operator Precedence
126. XML
127. Save Filter Settings
Top
blog comments powered by Disqus
Home

Sign In
Sign Up

FAQ
About
Help
Contact Us
Terms and Conditions

Tweet List

Link to us