VBA-Excel 380

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

Sorted from new to old.

Execute exe embedded in Excel

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

2021Apr16

ShapeRange_BG

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

2021Mar27

Excel crashes when File > Print

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

2021Mar6

Vertical page breaks

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

2021Feb24

InSheet_ChangeImage

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

2021Feb20

Row_PixelLocation

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

2021Feb2

SumOf_3Filters

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

2021Jan29

ToolPath

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

2021Jan12

EnvironList

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

2021Jan12

Hiding chart in Excel

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

2020Dec31

Generate_PowerPoint

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

2020Dec22

Save Excel range (or shape) to picture

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

2020Dec21

BrowseImage

Asks user to select an image and returns full path and name of selected image ...

2020Dec19

Quarter_to_Words

Convert Quarter code to text per special project requirements. A special ...

2020Dec17

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

ANmaCopy_Objects

Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...

2020Nov11

1 2 ...15 ...23 24