Search results 599

Sorted from new to old.

ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

2018Jun11

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

FixPath, IsThere, IsThere1 ...

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

2018Jun11

FileDate_Formatted

Using FileDateTime to get file date

2018Jun10

FindName

Finds a name in a workbook, returns true or false

2018Jun10

1FileDB

DB in a File (One of my best library codes so far) Saves/Reads/Deletes certain ...

2018Jun9

Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

2018Jun8

FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

Filter_GotoItem

Allow users to select from list box based on search terms. Have a text box and ...

2018Jun7

ComputerSN

Reads Serial number of the system, also can be used to return System name, ...

2018Jun6

FindIn1DArray

Returns 1 if an item found in array, 0 if not

2018Jun6

Time2Real

Converts TIME code to number HH:MM to xx.xx As in 10:15 to 10.25, 13:30 to 13.5

2018Jun2

RGB2Long

Converts Red, Green and Blue integers into RGB long value

2018Jun2

Paragraph2Line + Line2Paragraph

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...

2018Jun2

Crypt512

To encrypt or decrypt any string ' Strii is the required text to protect ' ...

2018Jun2

1 2 ...34 ...37 38