Components 179 Controls, objects and classes, also cells, sheets, workbooks in VBA-Excel

Card image cap
SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

Card image cap
HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

Card image cap
Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

Card image cap
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

Card image cap
Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

Card image cap
ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

Card image cap
ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

Card image cap
EmailSend_Outlook

Send email using Outlook object with attachments With AI-generated post image. ...

Card image cap
Windows Common Controls 6.0

This is the needed library to have Windows Common Controls installed to be used ...

VisualBasic6-KB896559-v1-ENU.zip

Card image cap
NavigatePost

Reads content of webpage with optional post data two main differences from

Card image cap
Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

Card image cap
SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...