Search results 249

Sorted from new to old.

DateOffset_FromMMDD

Calculate the new MMDD from a date formated as MMDD after adding/subtracting ...

Apr9

rel nofollow

Outside link no follow. html nofollow of rel No more confusion if it is ...

Feb13

Hack VBE password in .xlsm

Remove VBE project password protection off of xlsm. This is screenshot on how ...

2025Dec30

Textbox_PartialBold

Set part of textbox to bold, starting from StartingChar (like : ) that found in ...

2025Nov13

Pagebreak and Pagebreak preview

When setting the location of pagebreak, you need to have that sheet view set to ...

2025Nov11

Variable_PerLocation_FromFullLine

Extract set from ANstring, like 2nd set of variable list using specific ...

2025Oct16

Formulas_FromRow_toFile

Exports all formulas in a row of sheet into text file.

2025Oct10

ShapeCreate_SomeVariables

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

2025Sep30

Site as app (PWA)

Instructions on how to convert a website into an app, called Progressive Web ...

2025Jun19

Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

2025Jun1

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

2025May30

NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

2025Apr10

VBA/Excel Registry hacks

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

2025Mar12

ListBox_Read and ListBox_Save

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

2025Mar11

SettingRead_Bulk

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

2024Nov3

GetPapa + GetSon with variances

Gets the parent folder full name from a path Also Gets the son of a full path. ...

2024Oct26

1 2 ...15 16