ServerUptime

Return how long the computer has been running. Return format is dd:hh:mm:ss ...

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

WelcomeSheet.zip

[TAB] inside textarea

Allow textarea's to accept TAB key (ASCII code 63) Could use some enhancements, ...

TabManager.zip

FileDateTime

Gets time and date for a file, Date created, accessed or modified. If the file ...

Numeric-only textbox

Allow only Currency into textbox, text box will allow only nnnn.nn where n=1 ...

MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...

FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

Multi-line Textbox focus bug

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

FrmPass

Prompt for a password, or username and password, returns information back to ...

FrmPass.zip

Paging with Alternating Colors

This script will take the results of a query and sets up number of records per ...

Recurse and Rename

Recurses down a directory tree and renames files