Search results 63

Sorted from new to old.

FormatNumbers_InsideText

Formats all numbers found inside text to certain format. Excluding numbers ...

Mar9

FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

2025May25

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

2025Apr18

ListItemText_to_ListIndex

Finds the index of an item in listbox (or combobox) It searches for that item ...

2025Mar24

VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

2025Mar12

RegExPatternMatch

Checks string against pattern using RegEx (VBScript.RegExp). The pattern ...

2024Nov10

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

RoundUp2

Rounds a number to nearest identifier up. Like 105 up to nearest 20 ...

2024Oct1

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

2023Aug1

NavigatePost

Reads content of webpage with optional post data two main differences from

2023Jan14

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

CopyFiles

Copies files from list of files into a folder. Uses list of files with ...

2022Feb3

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

Frm81 - FullDetails

Show window of details, can be used to show content for certain cell, or show ...

2021Jun26

1 2 3 4