Search results 354

Sorted from new to old.

ListBox_SelectionCount

Counts how many items selected in a listbox (multi-selection listbox). Works ...

2022Apr21

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

GetGroupMembers

List All the Members of a Group Needs GroupNames text file having list of ...

2022Feb1

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

2021Nov26

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

tag_add

Add to textbox from listbox (select option) ensure its uniqueness

2021Aug24

DegreesToXY

Calculates X, Y of position on a Circle or ellipse. Pass the center X, Y of ...

2021Jun13

setSelectedIndex byname and byval

Set active (Selected) item in listbox using javascript Imported and modified ...

2021Jun10

1 2 ...7 ...22 23