Excel Books

Books that I own and use while developing in Excel

Donate with PayPal

If you have benefitted from the tutorials on this site, please make a donation to support further development.

Here are a few miscellaneous tricks and techniques I've learned.

Property Procedures - Passing Information to and from Forms

This page give a simple example showing how property procedures can be used to pass information to and from a userform.

List and Print Excel Files (Zipped Excel File)

This workbook contains the code to:

Open a form with buttons and a list box for filenames,
Use Browse4Folder to let the user select a directory,
Allow the user to select one or more files from this directory, and
Print the selected files.

Convert Fahrenheit to Celcius (Zipped Excel File)

I got tired of manually entering a formula into a workbook, typing in a number, and pressing enter when I needed to convert those heathen Celsius numbers into my beloved Fahrenheit, and vice versa (I'm in the American metalworking industry, okay??). I designed this form to accept a number, then when it saw a letter corresponding to F or C, convert it into its equivalent.

This workbook contains the code to:

Open a form with a text box for numeric data entry,
Recognize when "F" or "C" is entered after a number, and
Convert the value preceding the letter into its corresponding value in the other system.

ASCII Table (Zipped Excel File)

This workbook contains a sheet of all ascii character codes from Alt-0033 (!) to Alt-0255 (ÿ) in four fonts of your choosing. Don't see a character you like? Click on the floating menu and select up to four new fonts.