Excel 2003 VBA

Press Ctrl+F and then type the topic of your interest to quickly and easily access the relevant articles and videos.

Visual Basic for Applications – VBA – Macros in Excel 2003

The macros created in Excel 2003 will work in the later versions of MS Excel also. You may sometimes need to tweak them a little bit.

  1. What is a macro?
  2. Recording a macro
  3. Recorded macro code
  4. Simple Macro – How to write your first macro
  5. Entering data using a macro
  6. Formula macro
  7. Macro in VBA to perform calculations
  8. Create a new workbook with VBA
  9. Opening a workbook
  10. Refer to sheets by Index Number
  11. Refer to sheets by name
  12. Refer to ranges using the A1 notation
  13. Refer to cells using index numbers (r1c1 reference)
  14. Refer to rows and columns in macros
  15. Refer to cells by using shortcut notation
  16. Refer to named ranges
  17. Refer to cells relative to other cells
  18. Refer to cells by using a range object
  19. Refer to all cells on the worksheet
  20. Referring multiple ranges
  21. Looping through a range using a FOR NEXT LOOP
  22. Selecting and activating cells
  23. Working with 3-D Ranges
  24. Working with active cells
  25. Using a command button
  26. Calling a Worksheet Function
  27. A macro using the PMT function
  28. Creating a User-Form or a custom dialog box – Step 1
  29. Adding more controls to the user form – Step 2
  30. Adding code to controls – Step 3
  31. How to capture data from a user form to an Excel worksheet
  32. How to compare the captured data with the login data to verify a user
  33. Calendar control tool
  34. Date and time picker tool
  35. ‘FOR LOOP’ macro
  36. For Each… Next loop
  37. CurrentRegion property
  38. Data Forms
  39. Troubleshoot a macro
  40. A macro for formatting & calculations
  41. Pay-Packet calculation with a macro
  42. Creating custom functions
  43. Macro for text handling
  44. Nested loops macro to delete duplicates
  45. A sample project
  46. Running multiple macros in a worksheet
  47. Attaching the above macro to a command button
  48. Offset cell property – an interesting macro
  49. Macro in Excel for inventory solution
  50. Charts and VBA