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