PDA

View Full Version : VBA Ninja-Tips and Tricks



  1. How to count number of occurrences of a character in a string?
  2. Open all files in selected folder and perform some operation
  3. How to start writing macros?
  4. The Excel Object Model of VBA
  5. How to extract cell comments of all sheets using VBA?
  6. How to extract all Cell Names in a file?
  7. Save all images in a sheet to a folder using VBA
  8. Triggering a macro upon change in worksheet
  9. Efficient way to search an Excel sheet through a User Form
  10. How to make an Excel Cell Blink?
  11. Excel VBA Macro Security
  12. Housie / Tambola Game in Excel VBA
  13. Find Replace '?' (Question Mark) and '*' (Asterisk) Characters using VBA