Search results 74

Sorted from new to old.

VBA/Excel Registry hacks

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

Mar12

ListBox_Read and ListBox_Save

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

Mar11

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript

2024Aug11

DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

2024Jul25

Microsoft Edge gestures

Microsoft Edge Right-mouse gestures I found that will really save me time ...

2024May27

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

2024Apr19

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18

ListBox bug with TabIndex

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

2024Apr15

Lazy image loading + placeholder

Setup lazy image loading plus setting placeholder to images. Using

2024Feb10

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

SettingRead_Ajax + SettingRead_Ajax_IntoObject

Two functions to return an output of file into object on page or back to caller ...

2024Jan12

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

2024Jan9

SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

2024Jan8

CutString9

Cuts from CutFrom starting from any of items found from ...

2024Jan7

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

1 2 3 4 5