Search results 263

Sorted from new to old.

IIF

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

2018Jul7

FileDateTime

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

2018Jul5

PI

Returns a double representing the mathematical constant Pi

2018Jul5

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

DownloadFile_User

Downloads file to user, asking user where to save or to open downloaded file

2018Jun30

Numeric-only textbox

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

2018Jun27

CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

2018Jun26

TimeRound

Rounds the number of minutes to the nearest quarter of half like 4:32 to 4:30 ...

2018Jun25

ShowAgain2

Make selected item in listbox to be displayed at center of listbox after ...

2018Jun24

CellHyperlink_ToSheet

Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...

2018Jun24

CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

2018Jun22

AreTheyTheSame

Compares between two files in binary mode and returns true if they are ...

2018Jun20

Hex2Dec

Converts hexadecimal strings into decimals

2018Jun20

Dec2Hex

Converts integer decimals into Hexadecimals

2018Jun20

ScreenRes

Reads screen resolution, using IE this time, this one will get the active ...

2018Jun17

1 2 ...15 16 17