Search results 319

Sorted from new to old.

FixPath, IsThere, IsThere1 ...

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

2018Jun11

1FileDB

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

2018Jun9

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

MoveDown + MoveUp

Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...

2018Jun2

Time2Real

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

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

StringFlip

Flips a string, right-to-left, and if passed again, will flip it back Can be ...

2018Jun2

ANStrColor2RGB + RGB2ANStrColor

Converts R:G:B into RGB value (as long) and RGB from long into R:G:B

2018May30

CutString

Cuts a string from certain char till certain char, can be used to cut left, ...

2018May29

Str2Hex

Convert a string to Hex

2018May28

GetDigits

Extracts digits out of a string

2018May27

Number_Formatted

Format the number as ' <1000 = 1,2,55, 85, 989 ' <1000000 = 1K, ...

2018May26

CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23

VBA Progressbar (Frm73)

Progress bar Frm73 or just simple message Zip file contains .frm and .frx ...

2018May16

1 2 ...19 20