Components 192

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

Sorted from new to old.

FindSheet

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

2018Jun7

Multi-line Textbox focus bug

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

2018Jun7

Filter_GotoItem

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

2018Jun7

ComputerSN

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

2018Jun6

FindIn1DArray

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

2018Jun6

Numbers in Textbox

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

2018Jun6

MoveDown + MoveUp

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

2018Jun2

CopyText2Clipboard

Copies text to clipboard using MSForms

2018May30

Email-CDONTS

CDONTS with Attachment Example of CDONTSwith attachment for emailing

2018May27

CountColumnCells + CountColumnCells_Criteria

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

2018May23

GoToInternet

Opens webpage from within Excel, using default browser

2018May22

Navigate

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

2018May22

SettingRead+SettingSave

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

2018Apr27

LDAP / SiteServer Migration

This script will migrate LDAP and SiteServer user list to another LDAP ...

2018Apr23

Limit Characters in a TextArea

This will limit the number of characters a user types in a textarea.

2018Apr18

Run Application (ping.exe)

This script uses WSH to open an executable and save the results to a textfile.

2018Apr16

1 2 ...11 12