Code Snippits

These are VBA Code Snippits which I reuse in other applications.

Create it once, use it many times :)


 * Excel VBA
 * Excel Colours Index For VBA
 * Pull Username or Machine Name
 * Merge Several Tabs into first sheet
 * Connect To A Database & Submit (From VBA Form)
 * Connect To A Database & Pull Data (To VBA Form)
 * Connect To A Database & Pull Data via SQL (To Excel Sheet)
 * Send E-Mail
 * Dynamic Charts
 * Time Format Check (In Textbox)
 * Check Date Format (In Textbox)
 * Force only allows characters (In Textbox)
 * Force Currency Conversion (In Textbox)
 * Switch Workbook
 * Stop X Button use on Forms
 * Display A Screen Splash On Startup
 * Auto Open Form
 * Remove Sheet Passwords
 * Quit Excel
 * Print Dialogue Box
 * Multi Line Message Box
 * Call Access Macro From Excel
 * Force Close Excel
 * Difference Between Dates
 * Grab File Focus
 * Activate VBA Code on Sheet Change
 * Stop User Saving Document under another name
 * Automatic Selected Row Highlight
 * Run Code When User Exits Cell
 * Conditional Formatting (Over built in 3 limit)
 * Open Dialog in Excel via VBA
 * Extract A File Name From A File Path
 * Clear Used Range From Excel Using VBA
 * Use an array to unhide many sheets at the same time
 * Work out the First & Last Day of the month in VBA
 * Copy down formula dynamicly to used cell range only
 * Reduce Excel file size by reminding excel of last used cell
 * Update Excel Status Bar with Custom Messages
 * Update a Cell and Date/Time Stamp in another
 * Force List Box Selection


 * Excel VBA (Report Templates)
 * Glasgow Report Template


 * Excel Formulas & UDF's
 * Display Day Name from a date cell
 * Real Big Time
 * Add Working Days
 * Work Out First Date of The Month


 * Access VBA
 * Run Macro at set time

Back To The Home Page