Components 195

Controls, objects and classes, also cells, sheets, workbooks in VBA-Excel
  2. Categories
  3. Components
Sorted from new to old.
Card image
ListBox_SelectedIndexes

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

2018Jun11
Card image
Col2Combo

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

2018Jun10
Card image
FindName

Finds a name in a workbook, returns true or false

2018Jun10
Card image
FindSheet

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

2018Jun7
Card image
Multi-line Textbox focus bug

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

2018Jun7
Card image
Filter_GotoItem

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

2018Jun7
Card image
ComputerSN

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

2018Jun6
Card image
FindIn1DArray

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

2018Jun6
Card image
Numbers in Textbox

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

2018Jun6
Card image
MoveDown + MoveUp

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

2018Jun2
Card image
CopyText2Clipboard

Copies text to clipboard using MSForms

2018May30
Card image
Email-CDONTS

CDONTS with Attachment Example of CDONTSwith attachment for emailing

2018May27
Card image
CountColumnCells + CountColumnCells_Criteria

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

2018May23
Card image
GoToInternet

Opens webpage from within Excel, using default browser

2018May22
Card image
Navigate

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

2018May22
Card image
SettingRead+SettingSave

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

2018Apr27
12...1213