![Goto Guest book sign in page [Home]](files/guestbook.gif)
| VBA - Quick routines | ||||
| What | Discription | Link view | ||
| Environmental Variables | Gets Envoronment variables via VBA & API method - Shows what you can use this for and how to get yours. | < View this | ||
| Show [About] form | Add a bit of spice to your programs. Show the Windows Operating System About form, but Add your details eg. Application name, Your name and date etc. | < View this | ||
| GetColumn Letter | Just one way to get the column letter(s) | < View this | ||
| Processor speed | Gets your processor speed and make | < View this | ||
| Computer info | Get your computer system info eg Model, make, ram etc | < View this | ||
| AutoSum | VBA method to use AutoSum method on the Activecell, simulates pressing the Autosum button | < View this | ||
| Proper case change | Convert a selection of text to proper case | < View this | ||
| Open/Close CD | Commands to open and close your CD Drive door (or coffee holder !!) | < View this | ||
| Find all Files Dialog | Routine to show the Windows [Find ALL files] dialog Win9x and the [Search] for Win XP | < View this | ||
| Clean Cells with unprintable text characters | This routine removes all nonprintable characters from text cells and all spaces except for single spaces between words. Run this routine when you have downloaded Text from web sites etc. | < View this | ||
| Add images to comments | Routine to Add image files to comments for a different looking comment. | < View this | ||
| Get Cell Alignment info | Routine uses XL4 macro to get the Activecell Alignment | < View this | ||
| Disable Cut Copy & Paste | Disable ALL Cut Copy & Paste functionality | < View this | ||
| Timed MsgBox | A method to dismiss a messagebox after a certain amount of time, in Secs | < View this | ||
