Search results 145

Sorted from new to old.

CopyRowHeight

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

2019Aug1

Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

2019Jun16

IsThere_Remote

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

2019Jun7

DirTree.xlsb

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

2019May20

Pure CSS line graph

Simple, with CSS only, an HTML line graph By

2019May9

DialChart - Excel-VBA

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

2019Apr27

Web browser in Excel VBA

Example on how to use Web browser control inside Excel userform

2019Apr25

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

Porting Excel/VBA into OpenOffice Calc

PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic

2019Feb8

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1

User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

2019Jan9

Open different Filestypes

Populate list of filetypes in Application.GetOpenFilename method. This command ...

2019Jan9

Val2

Converts anything into an integer I used the function VAL() a lot, it is in ...

2019Jan3

Show/hide ribbon

Show or hide Excel ribbon from inside VBA Needed that in one of my projects

2018Dec30

ChrW

Insert special characters inside Cell, using ChrW

2018Sep19

TreeView

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

2018Sep2

1 2 ...6 ...9 10