VBA-Excel 329

Visual basic for applications that works only in Microsoft Excel, aka macros

Sorted from new to old.

ShowImage

Show an image using irfanview or Windows 7 image viewer. Looking to add more ...

2020Feb16

Evaluate

Execute any command in Excel VBE, using Application.Evaluate to execute almost ...

2020Feb16

Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

2020Feb5

Refreshing image

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

2020Feb3

FilterSheet_1By1 + FilterSheet_Clear

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

2020Jan3

Add2Column

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

2020Jan3

Copy formulas

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

2019Oct3

CopyRowHeight

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

2019Aug1

MatchLastIf

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

2019Jun12

IsThere_Remote

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

2019Jun7

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

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

2019Jun2

DirTree.xlsb

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

2019May20

DialChart - Excel-VBA

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

2019Apr27

Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code

2019Apr25

Web browser in Excel VBA

Example on how to use Web browser control inside Excel userform

2019Apr25

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

1 2 ...14 ...20 21