Excel VBA User Forms and Input Boxes
The following are links to resources that will help you understand how to code user forms in Microsoft Excel using VBA. How to Use Input Boxes with Visual Basic for Applications Conditionally Displaying a Message Box How to Programmatically Increment a Date With a Spinner Fill a ListBox with unique values from a worksheet Populate Dialog Decide what an INPUTBOX is supposed to return How to...
Read MoreExcel Math Functions
The following links take you to articles and tutorials that teach you the ins and outs of the math functions in Microsoft Excel. Two functions to calculate a factorium (n!) Return random numbers How to Use the FREQUENCY Function Using multiple criteria in SUMIF Function Summing Values in a Range Containing Redundant Spaces Summing the Number of Hours an Employee Worked During a Two Week...
Read MoreWord VBA Printing
The following are links to resources that will help you to understand all there is to know about WordBasic and printing. Printing All Open Documents with WordBasic How to save each mail merged letter as a separate file How to set the paper tray to be used when printing Printing Color Separations with VBA Using Sequential Document Serial Numbers Printing without Footnotes Temporarily Changing the...
Read MoreWord Macros and VBA
The following links will provide help and tutorials on how you can create macros (and/or use VBA) in Microsoft Word. How to Use the Name…As Statement to Rename Files How to Convert Macros Between WordPerfect and Word Run a macro when a user double-clicks a button in the document Useful WordBasic commands that have no VBA equivalent Export all the code from a code module to a text file How...
Read More