Search results 62

Sorted from new to old.

ANmaCountChars_Direction

Counts how many times we found OfChar repeated in TheStr from one of two ...

2025May24

Custom Excel UI ribbon

Excel custom ribbon in details. A good article I use as reference to add custom ...

2025May11

VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

2025Mar12

VBInstr_Any

Search for string inside another, with ability to have multiple strings to ...

2024Nov15

Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

2024Sep29

RegSave, RegRead, RegDelete

Windows Registry read, save and delete branch node or key. Three functions use ...

2024Sep15

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

FontAwesome icons in Office apps

Best way to use FontAwesome set of icons in apps, mainly my Excel tools and ...

2023Jan31

File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

2022Dec27

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

Range_SaveAsImage

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

2022Feb16

tag_add

Add to textbox from listbox (select option) ensure its uniqueness Needs ...

2021Aug24

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

2021Apr16

Open Window

Open another window with java script (_blank) Setting up width, height, ...

2021Mar22

1 2 3 4