Search results 60

Sorted from new to old.

Excel 2408 bug

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

Sep10

ListBox bug with TabIndex

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

Apr15

PivotTable_ShowHideBlankItems

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

Jan22

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

End ( xlDown )

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

2023Aug28

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

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

GetHeaders

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

2022May5

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

2022Jan5

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

2021Nov26

Special chars

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

2021Oct13

Frm6 - ANmaMultiSelect

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

2021Jun23

ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

2021Mar27

1 2 3 4