General VBA Tips

 

Many of the new items which will get added to the site will fall into the General VBA tips category.  I expect this area to be the most heavily updated.  The following are the current links.

  • Tick All ActiveX CheckBoxes
  • Autofit Merged Cells
  • Subtotal on the Fly
  • Hide Rows with VBA
  • Unique Random Number Generator
  • Unhide All Sheets with VBA
  • Automate Workbook Email
  • Dollars to Words with VBA
  • Show Picture with VBA
  • Cell Interior Colour in Excel VBA
  • Link Hyperlink to Excel Macro
  • Find Duplicates with VBA
  • Add Colour to Shape VBA
  • Protect Unprotect a Worksheet with VBA
  • Cascading Dynamic Drop Downs
  • Add Boarders with VBA
  • Sum with VBA
  • Add Toggle Button
  • Birthday Formula Excel
  • Column Differences
  • Break Workbook Links VBA
  • Compare Two Worksheets
  • Colour Button on Click
  • Random Button Colour
  • Create SQL on the Fly
  • Heat Map in Excel
  • Create SQL on the Fly
  • Automatically Filter
  • A Timer with VBA
  • Insert Picture with VBA