Downloads - Microsoft Excel Examples - as soon as we have a few more files available we will be setting up this page using an easier to navigate method. Until then, just use the Edit > Find function of your browser to locate the file that you are looking for.

If you have trouble downloading by left-clicking the link, then try right-clicking and select 'Save Target As...' from the right-click menu.
If trouble persists then just email and we will be happy to send you the file(s) you request!  :)
 

Classics & Old Reliables

• Activate / Deactivate Hyperlinks - as the title implies; activate 'em or deactivate 'em

• Add to Right Click Menu - covers adding right click to the worksheet - and a userform!

• Basic Message Box Examples - variety of message boxes that you can use today

• Basic Data Validation - create a 'dropdown' list for your worksheet! Just click and select your choices! It's so easy. (Basic Example)

• Bunch of Subs v1 - group of subs designed to demonstrate some of Excel's Power (more to come!)

• Calculate the Cube - very simple logistics tool to calculate the cube of an object or entire shipment. Crude, but useful.

• Calendar Creator - Using code that is available from Microsoft, this app creates calendars with Excel.

• Find a Worksheet by name - If you have a lot of worksheets you can search for them easily.

• Get Last User - This file is a bit involved but so easy to use.

• Get your IP Address - Not hot on the list of needs but still interesting

• List Open Workbooks - This code will pop up a userform listing open workbooks with 'Click to Go' capability!

• List Outlook's Inbox items - Will look in your inbox and create a new WB listing the inbox content.

• Move Data v1 (using open WBs) - Move data from one open workbook to another open work book.

• Protection: Turn Sheet Protection Off and On Programmatically - the title pretty much says it all.

• Random Numbers - Contains several worksheets and modules for generating random numbers in different formats.

• Save: Do Not Save On Exit - Contains code that will close the workbook and not save on exit - no prompt to save!

• Save: Save and Exit Excel Application - this code will save the current workbook(s) and then close Excel entirely - no prompt to save!

• Save: Save On Exit - Contains code that will close the workbook and save it on exit - no prompt to save!

• Select Worksheet or Cell or Both during the Workbook open event - does what the title suggests. Several methods included.

• Set The Scroll Area - This workbook will open to a predetermined, vertical scroll area

• Test for Match v1 - using color! - Will test for matching data in columns that are supposed to contain identical data.

• Timer Sub v1 - A simple timer set to activate a message box. Use it to build a more complex series.

• View Webpage in XL - This little dandy will allow you to view a webpage while actually working in your workbook.

• Command Button Chase - catch the command button to click it.

• Expiring Workbook - A simple way to expire the contents of a workbook. Use with caution.

• Round about - Recurring message boxes with a sorry warning. Use with caution.

More Advanced and/or Specific Use Examples

Yes, they're coming...it's been busy here - we haven't forgotten you!               Bookmark this Page?

• Convert Formulas to Values - this file contains code that will let you convert a region or an entire worksheet to values only.

• Toggle Button Basics - this file contains the basics of Toggle Button use plus a few other minor routines.

• Lookups 101 - this file contains ONLY formulae and covers some uses of VLookup and HLookup. This is a basic formula example file.

Copyright © 2000 - 2005 PiersonTech.com. All Rights Reserved.
Questions about this website? Please contact: Webmaster At PiersonTech