MM0025 - 18/05/20 - 10 Ways My Excel VBA Has Improved In The Last 10 Years

Looking back at your old work can be a great way to understand how you have got better - and how you can get even better from now!  In this stream, Chris reviews a file from 10 years ago and identifies 10 key improvements in his VBA coding.

Topics

  •  | Iain L - Homework Review
  •  | Common Mistake with Range(Range,Range)
  •  | VBA To Create Dropdown List
  •  | When To Use Copy / Paste Code
  •  | Jazfin
  •  | The One Mistake You Should Never Make
  •  | How To Use With … End With
  •  | Remote vs. Direct Referencing Example
  •  | Make Excel Not Look Like Excel
  •  | Should You Protect Your File?
  •  | How To Organise VBA Modules
  •  | The Leanest Way To Move Data
  •  | Should You Be Using Userforms?
1 Lesson