Convert2SQLDate

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

ListBox_SelectedIndexes

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

FrmAbout

Display a string in a Userform as 'About' window, can display string or file by ...

FrmAbout.zip

Col2Combo

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

FindName

Finds a name in a workbook, returns true or false

FindSheet

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

Multi-line Textbox focus bug

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

Filter_GotoItem

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

ComputerSN

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

FindIn1DArray

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

Numbers in Textbox

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

MoveDown + MoveUp

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