Powered by Invision Power Board

Recommended Sites: - VBA Express - JMT Forums - MrExcel - Ozgrid - MS Discussion Groups - John Walkenbach - Chip Pearson - Stephen Bullens Excel Page - xlDynamic (Bob Phillips) - JKP (Jan Karel Pieterse) - The Xcel Files (Ivan F Moala) - The Excel Maniacs (Gareth) - Scriptorium (Rembo) - ExcelKB (XL-Dennis) - and don't forget to register here - it's free!...
  Start new topic

Excel VBA Demo Code
Topic Title Topic Starter Replies Views Last Action
No New Posts   Add & Delete Ole Button And VBA Code
Just to show how...
johnske 0 699 March 19, 2006
Last Post by: johnske
No New Posts   Adjust To Users Screen Resolution
Change screen resolution
johnske 0 728 March 19, 2006
Last Post by: johnske
No New Posts   Apply Carriage-return & Line-feed_Worksheet
Automatic return and feed
johnske 0 314 March 19, 2006
Last Post by: johnske
No New Posts   Autobackup Workbook
Template for autobackup workbooks
johnske 0 300 March 20, 2006
Last Post by: johnske
No New Posts   Basic Invoice Book
Ready to use!
johnske 0 323 March 19, 2006
Last Post by: johnske
No New Posts   Browse & Import Code Modules
Import code modules via macro
johnske 0 331 March 20, 2006
Last Post by: johnske
No New Posts   Call IE And Link To Web-site
Using Internet Explorer
johnske 0 268 March 19, 2006
Last Post by: johnske
No New Posts   Change Excel Icon
(Sometimes useful)
johnske 0 867 March 20, 2006
Last Post by: johnske
No New Posts   Check Compatibility Of Office Versions
Check whether code will work
johnske 0 295 March 19, 2006
Last Post by: johnske
No New Posts   Code as you go
Don't have sheet code cluttering sheets
johnske 0 251 March 20, 2006
Last Post by: johnske
No New Posts   Concatenate Function
Concatenate all cells in a range
johnske 0 693 March 20, 2006
Last Post by: johnske
No New Posts   Delete Duplicates in Cells
Remove all duplicated entries
johnske 0 616 March 20, 2006
Last Post by: johnske
No New Posts   Delete Hyperlinks, Links, Formulas From Book
(Says it all)
johnske 0 241 March 20, 2006
Last Post by: johnske
No New Posts   Delete Links To Other Sheets Or Books
(Leave values and code)
johnske 0 674 March 19, 2006
Last Post by: johnske
No New Posts   Delete Links, Formulas (worksheet)
Delete all links
johnske 0 392 March 20, 2006
Last Post by: johnske
No New Posts   Delete Styles From Other Workbooks In Folder
Style multi-delete
johnske 0 627 March 20, 2006
Last Post by: johnske
No New Posts   Diabetics Log
Handy workbook for diabetics
johnske 0 195 March 20, 2006
Last Post by: johnske
No New Posts   Download From HTML Site
Program a download
johnske 0 281 March 19, 2006
Last Post by: johnske
No New Posts   Enter Date In Cell(s) Using MS Month View
Use MS monthview calendar control
johnske 1 1,250 March 30, 2006
Last Post by: johnske
No New Posts   Exit Windows
Logoff, shutdown, reboot, force
johnske 0 404 March 20, 2006
Last Post by: johnske
No New Posts   Extract Data from Closed Book
How to get data when a book is closed
johnske 0 954 March 20, 2006
Last Post by: johnske
No New Posts   Follow Any Path
ActiveWorkbook Path
johnske 0 571 March 19, 2006
Last Post by: johnske
No New Posts   Force Macros
Force users to enable macros
johnske 0 909 March 20, 2006
Last Post by: johnske
No New Posts   Forward & Back function
Bookmark locations to go back to
johnske 0 268 March 20, 2006
Last Post by: johnske
No New Posts   Get Userform Metrics
Use to hard-code all form metrics
johnske 0 342 March 20, 2006
Last Post by: johnske
No New Posts   Hide the Gridlines
Autohide gridlines
johnske 0 272 March 20, 2006
Last Post by: johnske
No New Posts   Hide The Zeroes
Don't show zero values
johnske 0 244 March 20, 2006
Last Post by: johnske
No New Posts   Hide Unused Rows
(Unhide used rows)
johnske 0 671 March 20, 2006
Last Post by: johnske
No New Posts   Import Notepad & Wordpad Text Files
Put text into a spreadsheet
johnske 0 235 March 20, 2006
Last Post by: johnske
No New Posts   Install/uninstall Activex Controls .ocx/.dll
(Includes month view calendar control)
johnske 0 421 March 20, 2006
Last Post by: johnske
No New Posts   List Macros
List all macros in workbook
johnske 0 376 March 20, 2006
Last Post by: johnske
No New Posts   Lock Excel when inactive
Secure your workstation when absent
johnske 0 234 March 20, 2006
Last Post by: johnske
No New Posts   Log Dates/Times a Books's Been Opened
Catch the company spy :)
johnske 0 334 March 20, 2006
Last Post by: johnske
No New Posts   Move Direction After Hitting Enter
Set move direction automatically
johnske 0 281 March 20, 2006
Last Post by: johnske
No New Posts   One Line Find function
Streamline your Find functions
johnske 0 218 March 20, 2006
Last Post by: johnske
No New Posts   Open Any File Or Application.
Open anything with hyperlinks
johnske 0 652 March 19, 2006
Last Post by: johnske
No New Posts   Open At A Given Sheet And Range
Works even if sheet's been renamed
johnske 0 239 March 19, 2006
Last Post by: johnske
No New Posts   Open Web Page & Search
(From excel)
johnske 0 719 March 19, 2006
Last Post by: johnske
No New Posts   Populate Multi-column Combobox
Basic procedure
johnske 0 1,056 March 19, 2006
Last Post by: johnske
No New Posts   Programmatically Add Userform
Add form and code with vba
johnske 0 917 March 19, 2006
Last Post by: johnske
No New Posts   Put Cell in Top-Left (Goto)
The use of Goto
johnske 0 745 March 20, 2006
Last Post by: johnske
No New Posts   Recycle Worksheets
Reclaim sheets with old/wrong entries
johnske 0 220 March 19, 2006
Last Post by: johnske
No New Posts   Restore Default MS Size Of Workbook.
(Title says it)
johnske 0 227 March 20, 2006
Last Post by: johnske
No New Posts   Run Once Then Delete Code Module
Prevent code copying...
johnske 0 632 March 20, 2006
Last Post by: johnske
No New Posts   Run-once Code With Option
Specify if you want something run again
johnske 0 219 March 20, 2006
Last Post by: johnske
No New Posts   Save Copy Of Workbook Minus Some Sheets
(Title says it all)
johnske 0 322 March 20, 2006
Last Post by: johnske
No New Posts   Save Previous Value As Comment
Remember the last value entered...
johnske 0 332 March 20, 2006
Last Post by: johnske
No New Posts   Save Sheets As Books In Folder
Split up a workbook
johnske 0 729 March 20, 2006
Last Post by: johnske
No New Posts   Search All Books In A Folder
Opens & searches all books
johnske 0 314 March 19, 2006
Last Post by: johnske
No New Posts   Search By Regions
Quick-search
johnske 0 184 March 19, 2006
Last Post by: johnske
No New Posts   Set A Trial Period for Use
Stop unpaid use of your project
johnske 0 301 March 20, 2006
Last Post by: johnske
No New Posts   The Find Function Simplified + An Alternative
(Just to get you started)
johnske 0 277 March 19, 2006
Last Post by: johnske
No New Posts   Updating Your Project From Web
Put "check for updates" in your project
johnske 0 224 March 19, 2006
Last Post by: johnske
No New Posts   Use Command Button As Toggle Button
(Titla says it)
johnske 0 937 March 20, 2006
Last Post by: johnske
No New Posts   Use Standard MS Progress Bars
Two types of status bars
johnske 0 383 March 20, 2006
Last Post by: johnske
No New Posts   Used Region Function
Find the used region
johnske 0 229 March 20, 2006
Last Post by: johnske
No New Posts   Userform Start Position
Fine-tune userform start position
johnske 0 1,110 March 20, 2006
Last Post by: johnske
No New Posts   VBA Code Library
Attachment includes 75 code examples
johnske 0 459 March 20, 2006
Last Post by: johnske
No New Posts   Word - Default Page Setup
(No attachment)
johnske 0 390 March 19, 2006
Last Post by: johnske
No New Posts   Working With Multi-selections
Some examples
johnske 0 249 March 20, 2006
Last Post by: johnske
No New Posts   Working With Union And Intersect
Some demos
johnske 0 229 March 20, 2006
Last Post by: johnske
0 User(s) are browsing this forum (0 Guests and 0 Anonymous Users)
0 Members:
Showing 61 of 61 topics sorted by in from  

  Start new topic

Legend

Open Topic
(new replies)

Open Topic
(no new)

Hot Topic
(new replies)

Hot Topic
(no new)

Poll
(new votes)

Poll
(no new)

Locked
Topic

Moved
Topic
This additional symbol: indicates that you have participated in the topic
Search this forum: 
  Forum Jump:
 



Mark this forum as read