VBA-Excel 329

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

Sorted from new to old.

Frm9 - Select workbook (or workbook/worksheet)

Gives your user ability to select a workbook from list of open workbooks within ...

2019Apr3

SheetAdd_ANmar

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

2019Apr1

User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

2019Feb1

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

RunRemote

Runs a macro from another workbook without parameters (WB Workbook has to be ...

2019Jan9

Protect VBA

Protect VBA project from inside VBA This is the raw way, there has to be other ...

2019Jan1

Show/hide ribbon

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

2018Dec30

Permission Denied error

Issue: Trying to copy file (Using VB command FileCopy) while that file was ...

2018Sep26

TreeView

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

2018Sep2

Listbox height changing issue

Listbox in Excel sometimes have issue adjusting height to items added inside, ...

2018Aug25

Scrolly

Scroll a listbox Using Right-Drag. (Something VBA in Excel lacks) You might ...

2018Aug25

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

2018Aug23

XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

2018Aug16

ChartMaxY + ChartMinY

Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...

2018Aug16

1 2 ...15 ...20 21