Search results 213

Sorted from new to old.

Capitalize1st

Capitalize 1st letter of a string

2018Jul15

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14

CreateZipFolder_7Zip

Creates a zip from folder using 7Z archive. 7za.exe (found in attached zip) ...

2018Jul14

CutString1

Cuts a string from a string starting from a specific character index and until ...

2018Jul11

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9

FaceIDs

Excel menu icons and icon ids (named FaceIDs) used when yu create toolbars and ...

2018Jul9

IIF

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

2018Jul7

Error_Raise

To raise a friendly error message with option to show custom error number and ...

2018Jul7

FindVBAObject

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

2018Jul6

oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

2018Jul6

Cookies warning

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

2018Jul6

PI

Returns a double representing the mathematical constant Pi

2018Jul5

ServerVar

Get value of Server variable by passing variable name aVar can be any of these ...

2018Jul4

DegreeC2F + DegreeF2C

Convert Celsius to Fahrenheit and Fahrenheit to Celsius degrees

2018Jul3

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

1 2 ...11 ...13 14