Search results 60

Sorted from new to old.

ANmaDropdown Search

Shows drop down menu of matching items when user searches in textbox with ...

May13

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

May10

Tabs-Auto-To-Menu

Turns tabs into menu based on available width. JS (Bootstrap 5) code to turn ...

May4

FirstDuplicatedItem

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

Apr18

ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

Apr17

ListItemText_to_ListIndex

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

Mar24

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

Mar11

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

2024Apr15

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

Multi-Select searchable drop-down in Bootstrap 5

Multi-select drop-down with search in Bootstrap 5 From

2023Nov25

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

Popup button

List of commands in popup menu. Uses listbox, command button and toggle ...

2022Oct13

Dropdown button commands

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

2022Oct12

1 2 3 4