Please note javascript is required for full website functionality.
MVP

VBA Blog Series

VBA Blog Series

Here is a complete list and respective links to all of our VBA blogs: 

  1. VBA: Introduction to VBA
  2. VBA: 1.1: Introduction to VBA: Recording macros
  3. VBA: 1.2 Introduction to VBA
  4. VBA: 1.3 Adapting Recorded Macros - Ranged Names
  5. VBA: Cleaning Up Recorded Macros
  6. VBA: Using Message Boxes in Excel
  7. VBA: Updating your Status (Bar) in Excel
  8. VBA: If I use VBA then I get better at it!
  9. VBA: Declaring Variables
  10. VBA: For Loops
  11. VBA: Unhiding and Unprotecting Sheets
  12. VBA: Handling VBA Errors
  13. VBA: Speeding up The Pace of Running Your Macros
  14. VBA: Hidden vs Very Hidden
  15. VBA: An Eventful Month Coming up!
  16. VBA: Save The Event!
  17. VBA: Painting with Excel
  18. VBA: DoEvents
  19. VBA: Referring to Ranges
  20. VBA: Range Modifiers
  21. VBA: The Value of Declaring Variables
  22. VBA: Scoping Variables
  23. VBA: Constants is Her Name
  24. VBA: Unforget-TABLE, That’s What You Are
  25. VBA: Turning Tables
  26. VBA: Close Range
  27. VBA: DataBodyRange Part 1
  28. VBA: DataBodyRange - New Frontier
  29. VBA: Header-ache
  30. VBA: Total Eclipse of the Heart
  31. VBA: ListColumn
  32. VBA: ListColumn Swan Song
  33. VBA: Same Same But Different
  34. VBA: Having a Row
  35. VBA: Can’t Row with a Column
  36. VBA: Getting Loopy Each Time
  37. VBA: Wending down the hill Until you Do
  38. VBA: At Least Once in Our Lives, Let’s 'Do' It!
  39. VBA: 'Do' it 'Until' You Believe
  40. VBA: Lost and Found
  41. VBA: After You
  42. VBA: Looking Up and Down
  43. VBA: Digging Up
  44. VBA: Finding the Part of a Whole
  45. VBA: Matching the Case
  46. VBA: Find The Right Format
  47. VBA: Op-TRIM-isation
  48. VBA: Stop Reticulating Splines! - Part 1
  49. VBA: Stop Reticulating Splines - Part 2
  50. VBA: Going Through the Visual Basics – Part 1
  51. VBA: Going Through the Visual Basics – Part 2
  52. VBA: Going Through the Visual Basics – Part 3
  53. VBA: Going Through the Visual Basics – Part 4
  54. VBA: Going Through the Visual Basics – Part 5
  55. VBA: Going Through the Visual Basics – Part 6
  56. VBA: Going Through the Visual Basics – Part 7
  57. VBA: Going Through the Visual Basics – Part 8
  58. VBA: Going Through the Visual Basics – Part 9
  59. VBA: Going Through the Visual Basics – Part 10
  60. VBA: Going Through the Visual Basics – Part 11
  61. VBA: Going Through the Visual Basics – Part 12
  62. VBA: Going Through the Visual Basics – Part 13
  63. VBA: Going Through the Visual Basics – Part 14
  64. VBA: Going Through the Visual Basics – Part 15
  65. VBA: Going Through the Visual Basics – Part 16
  66. VBA: Going Through the Visual Basics – Part 17
  67. VBA: Going Through the Visual Basics – Part 18
  68. VBA: Selecting The Right Case
  69. VBA: Select Case Flexibility
  70. VBA: Selecting Case By Case
  71. VBA Blog: Charts and Macros
  72. VBA Blog: Charts and Macros 2

 

This list will be updated accordingly!

Newsletter