View Full Version: Excel VBA Demo Code

Excel VBA Demo Code topics

• Enter Date In Cell(s) Using MS Month View
• Forward & Back function
• One Line Find function
• Save Previous Value As Comment
• Diabetics Log
• Force Macros
• Concatenate Function
• Exit Windows
• Extract Data from Closed Book
• Lock Excel when inactive
• Code as you go
• Get Userform Metrics
• Delete Duplicates in Cells
• Run Once Then Delete Code Module
• Run-once Code With Option
• Hide the Gridlines
• Hide Unused Rows
• Used Region Function
• Import Notepad & Wordpad Text Files
• Put Cell in Top-Left (Goto)
• Log Dates/Times a Books's Been Opened
• Change Excel Icon
• Autobackup Workbook
• Save Sheets As Books In Folder
• Install/uninstall Activex Controls .ocx/.dll
• Set A Trial Period for Use
• VBA Code Library
• Move Direction After Hitting Enter
• Hide The Zeroes
• Use Standard MS Progress Bars
• Save Copy Of Workbook Minus Some Sheets
• Use Command Button As Toggle Button
• Browse & Import Code Modules
• Delete Hyperlinks, Links, Formulas From Book
• List Macros
• Delete Links, Formulas (worksheet)
• Delete Styles From Other Workbooks In Folder
• Working With Union And Intersect
• Userform Start Position
• Working With Multi-selections
• Restore Default MS Size Of Workbook.
• Basic Invoice Book
• Apply Carriage-return & Line-feed_Worksheet
• Open Any File Or Application.
• Open At A Given Sheet And Range
• Search By Regions
• Adjust To Users Screen Resolution
• Check Compatibility Of Office Versions
• Search All Books In A Folder
• Call IE And Link To Web-site
• Download From HTML Site
• Open Web Page & Search
• Delete Links To Other Sheets Or Books
• Updating Your Project From Web
• The Find Function Simplified + An Alternative
• Add & Delete Ole Button And VBA Code
• Follow Any Path
• Recycle Worksheets
• Populate Multi-column Combobox
• Programmatically Add Userform
• Word - Default Page Setup