Excel Tips and Tricks

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.