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

  2. Languages
  3. VBA-Excel
Card image cap
Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

Fri Apr16 9AM
Card image cap
ShapeRange_BG

Replaces the background fill of any shape in Excel with an image Not Ready yet, ...

Sat Mar27 11AM
Card image cap
Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

Sat Mar6 12PM
Card image cap
Vertical page breaks

Change Vertical page breaks in Excel spreadsheet preparing to print Looks like ...

Wed Feb24 7AM
Card image cap
InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

Sat Feb20 10AM
Card image cap
Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

Tue Feb2 11AM
Card image cap
SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

Fri Jan29 11AM
Card image cap
ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

Tue Jan12 9AM
Card image cap
EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

Tue Jan12 9AM
Card image cap
Hiding chart in Excel

How to hide a full chart in Excel. By treating it as shape, not as chart.

2020Dec31
Card image cap
Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22
Card image cap
Save Excel range (or shape) to picture

This is an interesting approach to export a range of cells into picture using ...

2020Dec21