|
Blank Excel
file with macro that formats chemical equations (Dr. Jeffrey Anderson) Click on cell with equation text then CNTL-z Formatting for equation text: '">" = forward reaction arrow '"<" = equilibrium arrow '"+" or "-" after character is assumed charge on ion eg. S-2 (-2 superscripted") ' asterisk character above now replaced with bold centered dot ' "DH" or "DG" or "DS" ... "D" converted to delta ' "hn" converted to h neu ' 0 after E,G,H,S superscripted ' f after 0 subscripted ' 0 before C,F superscripted *****Check back later and there will be a file posted that will contain a similar macro for Word files******* |
Adding Custom Macros to an Excel ToolbarBefore adding these custom buttons, you should create your own personal add-in. Don't worry, this is a piece of cake.
Creating a new macro button in a toolbar.
|
|
How to do just about anything with
Excel (Tushar Mehta Consulting - business analysis focus, however I have used many of the methods for science applications) Excel Tutorials and add-ins Charts Excel and VBA Case Studies VBA Tutorials |
|
|
Unit Converter Add-in List of Excel Functions (pdf) (xls) Display cell formulas as equations Excel file for graphing an equation Handy Toolbar (neat feature for creating new sheets with names) |
SIMTOOLS (statistics add-in) Interactive guide for finding Excel 2003 commands in Excel 2007 Calendar Templates Monte Carlo Simulations add-in |
