Search results 59

Sorted from new to old.

ShapeCreate_SomeVariables

Create a shape in certain sheet with options Some other options are hard-coded, ...

Sep30

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 Edit ...

2024Aug11

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

SQL Cross Apply String_Split with XML Path

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

2024Jan20

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

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-12-19: Fixing ability to ...

2023Nov12

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

Enable Includes in ASP Classic

Enable relative paths for ASP Classic includes to work. New servers do not ...

2023Aug7

1 2 3 4