Search results 176

Sorted from new to old.

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14

Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9

FaceIDs

Excel menu icons and icon ids (named FaceIDs) used when yu create toolbars and ...

2018Jul9

FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

2018Jun28

ShowAgain2

Make selected item in listbox to be displayed at center of listbox after ...

2018Jun24

ANBS controls

Set of functions to generate Bootstrap controls as strings. Controls available ...

2018Jun24

ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14

ListBox_SelectedIndexes

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

2018Jun11

Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

2018Jun8

Filter_GotoItem

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

2018Jun7

MoveDown + MoveUp

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

2018Jun2

DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

2018May31

DB_Setting2Read + DB_Setting2Save

Reads and save setting into settings table per 2 IDs, similar to SettingRead ...

2018May31

ANStrColor2RGB + RGB2ANStrColor

Converts R:G:B into RGB value (as long) and RGB from long into R:G:B

2018May30

CutString3_Search

Using same code in CutString3, this will search for matching items. Searches ...

2018May29

1 2 ...10 11