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

Card image cap
FindIn1DArray

Returns 1 if an item found in array, 0 if not

Card image cap
Numbers in Textbox

Force textbox to accept numbers only. Needs adjustments to work on VB6

Card image cap
MoveDown + MoveUp

Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...

Card image cap
CopyText2Clipboard

Copies text to clipboard using MSForms

Card image cap
Email-CDONTS

CDONTS with Attachment Example of CDONTSwith attachment for emailing

Card image cap
CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

Card image cap
GoToInternet

Opens webpage from within Excel, using default browser

Card image cap
Navigate

Downloads a certain page source into a variable, full content in HTML, using ...

Card image cap
SettingRead+SettingSave

This is the final version of my set of Setting functions SettingRead, ...

Card image cap
LDAP / SiteServer Migration

This script will migrate LDAP and SiteServer user list to another LDAP ...

Card image cap
Limit Characters in a TextArea

This will limit the number of characters a user types in a textarea.

Card image cap
Run Application (ping.exe)

This script uses WSH to open an executable and save the results to a textfile.