|
Peltier Tech
Chart Utilities
Excel Dashboards
Books at Amazon.com
Buy me a coffee
If this topic or the whole site has been helpful, please support further development by treating me to a cup of coffee.
|
|
Excel Tips and Tricks
Here are a few miscellaneous tricks and techniques I've learned.
|
This page give a simple example showing how property procedures can be used to pass information to and from a userform.
|
|
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.
|
|
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.
|
|
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.
|
|
|
