Tweet

Get a feed of new tips directly to your outlook

Learn VBA Step By Step

• Introduction to VBA Editor
• Record a Macro
• What does my recorded Macro code mean ?
• FOR Loops
• SUBS and FUNCTIONS explained 

 VBA Tips and Tricks

• Finding Things Using VBA
• Remove Hyperlinks
• Reset The Used Range
• Screenupdating Make Code Run Faster
• Time Your Code
• Worksheet Events
• Concatenate Range
• Run Code Every Hour, Minute or Second
• Keep Users Informed Of Code Progress - Update Statusbar
• Find The Last Cell
• Get Rid Of Annoying Message Boxes When Closing Excel
• Enable / Disable Events
• Turn Off Message Boxes Whilst Running Code
• Track Changes By Adding A Time Stamp
• Get A File Path
• Save A Copy Of A File Daily
• Write Your Own Excel Function
• Log An Audit Trail
• Import A Text File
• List Files In A Folder
• Pause Code
• Double Click
• Create An Index Page
• Email Workbook
• Call Code From Another Workbook
• Inputbox
• Selecting Things Demo
• Find Out If A Cell Is Within A Range
• Fast Search
• Convert Text To Number
  
• Smart Table Sorting using VBA
• Turn Off Autofilter

 Example Systems

• Share Trading System
• Noughts and crosses
• 4 in a Row

Useful Tools

• List Files In Folder
• Analyse A Workbook
• Merge 2 Data Sets
• Compare 2 Data Sets

 ExcelExperts.com contributed VBA Tips

• Empty Blank Modules in Excel
• List and Type of Drives
• Create Shortcut for Notepad on Desktop 
• Special Folders Path
• Evaluate vba concatenation
• Sheet Protect
• Concatenate Array
• sumif excel 2003 2007
• Create Access Table from Excel
• Unzip Files
• Alternative Text Property of Shapes
• Set Excel Environment
• Custom Properties
• Create Hyperlinks
• Check if exists in List
• Assign Macros to Shapes
• Form Control vs ActiveX Control
• Zip Files from Excel
• Customised Cell Comments
• Create a blank Access Database from Excel
• Record Keeping from Excel to Access
• Multi Level Sort
• Quick Immediate Window Commands useful for debugging
• Get Values from other workbook without opening
• Break External Links with other workbooks
• Color chart series utility
• Custom Number Formats
• Chart Zoomer
• Show Blank Chart or No Data on Empty chart
• Difference of two Ranges
• Find All Occurrences of string in range
• Lotus Email VBA
• Compact Access Database
• Align Shapes using VBA
• Export Excel Range to Access
• Outlook Email
• Read from Access Table into Excel
• Changing Data in Image Its Different No VBA coding
• Word Count in Cell using Split
• Array To ADO Recordset
• Filter Workaround Simulating Filter
• Classes Single event for multiple labels
• Chart Event Double Click on Chart
• Types of Message Boxes Simple ones
• Sorting ListBox Items alphabetically
• Export Excel Charts to PowerPoint
• Add Custom Options to Right Click Menu
• Creation Date of Excel File
• File Manipulation from VBA
• Using Instr with Optional Backward Search
• Start Position of a Nth Instance of String in a piece of Text
• Customised OnKey with example
• Check if a worksheet already exists in a workbook
• Extract Nth Word from a String VBA
• Excel VBA Data Validation Code
• Advanced Filter
• Copy values vba
• Date Stamped Report File