Search results 68

Sorted from new to old.

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

Control the Panel

A set of commands (or shortcuts) allowing users to access Control panel items ...

2019May19

Card14-BS3

Item card, or product card in bootstrap 3

2019Apr18

ArrSort_2Arr

Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...

2018Oct1

Listbox height changing issue

Listbox in Excel sometimes have issue adjusting height to items added inside, ...

2018Aug25

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

List_Load + List_Save

Loads/Saves items from/to text file to/from listbox Also has simple adding and ...

2018Jul26

ExcelMenu_onfly

Creates Excel menu on the fly, list of menu items, command actions, and icons ...

2018Jul17

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

MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17

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

FindIn1DArray

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

2018Jun6

1 2 3 4 5