Browse codes

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

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

6/10/2018 2:48:00 PM

Finds a name in a workbook, returns true or false

6/10/2018 2:21:00 PM

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

6/7/2018 3:44:00 PM

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

6/7/2018 2:34:00 PM

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

6/7/2018 2:20:00 PM

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

6/6/2018 8:17:00 PM

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

6/6/2018 7:59:00 PM

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

6/6/2018 6:30:00 PM

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

6/2/2018 4:55:00 PM

Copies text to clipboard using MSForms

5/30/2018 7:48:00 PM

CDONTS with Attachment Example of CDONTSwith attachment for emailing

5/27/2018 8:24:00 PM

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

5/23/2018 5:29:00 PM