Search results 517

Sorted from new to old.

FindFile

Finds if a workbook is open or not in same Excel session

2018Jul11

FS_CreateUserFolder

Creates a folder for a user, usually after sign up or login for first time. ...

2018Jul9

RGB2HTML + HTML2RGB

Converts RGB color to / from HTML format As bonus, functions RGB_ExtractColor ...

2018Jul9

CreateFullTree

Creates full tree if not found

2018Jul9

SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9

Win10 User Folders

I hate it when Microsoft takes back some controls it already gave to users, one ...

2018Jul9

Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9

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

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

1 2 ...27 ...32 33