Search results 204

Sorted from new to old.

Dropdown button commands

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

2022Oct12

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

ListBox_SelectionCount

Counts how many items selected in a listbox (multi-selection listbox). Works ...

2022Apr21

CopyFiles

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

2022Feb3

GetGroupMembers

List All the Members of a Group Needs GroupNames text file having list of ...

2022Feb1

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

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13

tag_add

Add to textbox from listbox (select option) ensure its uniqueness Needs ...

2021Aug24

Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

2021Aug13

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

1 2 ...6 ...12 13