Search results 218

Sorted from new to old.

Match2

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16

HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16

WaitFor + ShellWait

Tell App to wait for number of seconds and Execute command and wait for it ...

2018Jun16

HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15

OpenPassword + ClosePassword

Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...

2018Jun14

FrmAbout

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

2018Jun11

FindName

Finds a name in a workbook, returns true or false

2018Jun10

ComputerSN

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

2018Jun6

Numbers in Textbox

Force textbox to accept numbers only. Needs adjustments to work on VB6

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

Crypt512

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

2018Jun2

RoundUp

Rounds a number up, like Excel function RoundUP

2018Jun2

ANStrColor2RGB + RGB2ANStrColor

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

2018May30

Number_Formatted

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

2018May26

DownloadFile

Download a file from URL from inside Excel into certain path, returns blank if ...

2018May22

FilesIn + FilesIn_Count

Returns list of files found in a folder, list separated with custom separator ...

2018May22

1 2 ...13 14