Search results 524

Sorted from new to old.

IIF

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

2018Jul7

LoadPicture_Safe

Loads an image into VBA image control without knowing its extension If file ...

2018Jul7

FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

2018Jul7

FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

2018Jul6

Num2En

Convert number to English words, convert 450 to 4 hundreds and fifty dollars

2018Jul6

Cookies warning

Thanks to new law in Europe, we need to show users and let them accept a ...

2018Jul6

[TAB] inside textarea

Allow textarea's to accept TAB key (ASCII code 63) Could use some enhancements, ...

2018Jul6

SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

2018Jul5

SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

2018Jul4

SortArea1

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

2018Jul4

Sort1Col

Sorts a column in Excel, easily, with options

2018Jul4

DegreeC2F + DegreeF2C

Convert Celsius to Fahrenheit and Fahrenheit to Celsius degrees

2018Jul3

XorC

Simple small function to Encrypt or Decrypt a string Test_XorC is for testing ...

2018Jul1

SharePointURL2Path + Path2SharePointURL

Converts SharePoint URL to regular folder path and the other way, giving the ...

2018Jun30

DeleteAllFiles

Delete All Files in a Folder. Needs a reference to Microsoft Scripting Runtime

2018Jun30

FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

1 2 ...28 ...32 33