Search results 66

Sorted from new to old.

Encrypt1 + Decrypt1

Encrypts (and decrypts) a string. To decrypt an encrypted string, use the ...

2018Jul25

doHighlight

Search for occurrences of a keyword in a string and highlight them, by either ...

2018Jul19

URLs2Anchors

All links found inside a string into anchor (< a href=...) BUG!: Currently ...

2018Jul17

LogFile_Add

Adds an entry to log file, if file is not exist, it will be created. Filename ...

2018Jul17

WorkbookOpenAsk_ANmar

Asks user to browse to a file and return full path and file name if they do, ...

2018Jul17

ServerUptime

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

2018Jul11

WelcomeSheet

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

2018Jul9

[TAB] inside textarea

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

2018Jul6

FileDateTime

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

2018Jul5

Numeric-only textbox

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

2018Jun27

MatchIf_ThenDelete

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

2018Jun17

Reversefile

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

2018Jun16

FixPath, IsThere, IsThere1 ...

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

2018Jun11

Multi-line Textbox focus bug

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

2018Jun7

FrmPass

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

2018May20

Paging with Alternating Colors

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

2018Apr18

1 2 3 4 5