Search results 132

Sorted from new to old.

IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

2018Jul7

DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

2018Jul7

Limit Textarea

Show number of characters in a textarea and limit if it goes greater than ...

2018Jul5

GetTempFileName

Returns temp file name using FSO

2018Jul2

RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

2018Jun28

Numeric-only textbox

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

2018Jun27

WeekNum

Generates the calendar week number for a certain date, counting the first week ...

2018Jun26

RemoveChars

Removes all chars found in Chars_to_remove from String1

2018Jun22

File_FirstFound

Gets first file found matches a wildcards mask, using Dir()

2018Jun20

Hex2Dec

Converts hexadecimal strings into decimals

2018Jun20

BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

2018Jun16

Crypt128

Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...

2018Jun14

GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

2018Jun11

GenerateMemorablePassword

Returns a random password that is easier to remember, such as BONES or LAMOT. ...

2018Jun11

FrmAbout

Display a string in a Userform as 'About' window, can display string or file by ...

2018Jun11

1 2 ...7 8 9