Search results 28

Sorted from new to old.

MatchIf8

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

2025May10

ImageMSO list

List of all images in ImageMSO used in ribbon as well in other parts of VBA in ...

2025Apr30

HTMLCloseTag_HasWordAfter

Finds the number of occurrence of a "Numeric" inside a string having a certain ...

2024Oct6

NumberBeforeString_HTML

Cuts a number that would be found before certain word inside a block string. ...

2024Feb1

PivotTable_ShowHideBlankItems

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

2024Jan22

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

Popup button

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

2022Oct13

ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

2022Aug25

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

Too large procedures

No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...

2022Jan29

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

1 2