Browse codes

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

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15

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

2018Jun11

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

2018Jun10

Finds a name in a workbook, returns true or false

2018Jun10

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

2018Jun7

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

2018Jun7

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

2018Jun7

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

2018Jun6

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

2018Jun6

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

2018Jun6

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

2018Jun2

Copies text to clipboard using MSForms

2018May30