Refreshing image

Refreshing image in ImageControl of VBE Userform When we change picture of ...

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

CopyRowHeight

Copy row height from row to another Used to fix row heights or merged cells to ...

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

IsThere_Remote

Checks if a file can be reached online or no Same as

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

Protect or unprotect a workbook (already open) remotely from another workbook ...

DirTree.xlsb

Excel macro to show all files found in directory (including sub-directories) as ...

DirTree.zip

DialChart - Excel-VBA

A dial chart inside Excel using VBA code. With options to show 3 areas and two ...

DialChart.zip

Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

UnProtect.zip

Web browser in Excel VBA

Example on how to use Web browser control inside Excel userform

WebBrowser.zip