Search results 196

Sorted from new to old.

VBInstr (or Instr parameters)

The great function InStr I use a lot has a small confusing part. Which string ...

2019Jan9

Language per app

Restore Windows 10 setting to remember language selected per application

2019Jan9

RunRemote

Runs a macro from another workbook without parameters (WB Workbook has to be ...

2019Jan9

FormatPhoneNumber

Formats a given 10 digit number into a nice looking phone number

2019Jan5

Cookies Consent

Show cookies message based on new EU regulations with customization. Best one ...

2018Dec24

TreeView

A plain pure VBA Treeview control to be used inside Excel (official link has ...

2018Sep2

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

2018Aug23

Styles_DeleteNonStandard

Delete styles from an Excel workbook, any non-standard style will be deleted. ...

2018Aug12

CopyRange_NoClipboard

Copies range without using clipboard. Applies formats into a cell (or range) ...

2018Aug10

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

2018Aug9

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

2018Aug9

WorkbookClose_ANmar

Closes a workbook, checks if it is already open first, works for workbooks ...

2018Aug9

DegreeC2K

Convert a Celsius temperature to a Kelvin temperature. To convert Fahrenheit ...

2018Jul25

UnBreakAr + BreakAr

Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...

2018Jul25

CreateThumb_IrfanView

Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...

2018Jul22

1 2 ...10 ...12 13