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

Card image cap
ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

Card image cap
Col2Combo

Reads everything in a column (starting from certain cell until blank cell is ...

Card image cap
FindName

Finds a name in a workbook, returns true or false

Card image cap
FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

Card image cap
Multi-line Textbox focus bug

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

Card image cap
Filter_GotoItem

Allow users to select from list box based on search terms. Have a text box and ...

Card image cap
ComputerSN

Reads Serial number of the system, also can be used to return System name, ...

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