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

Card image cap
Listbox height changing issue

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

Listbox height changing issue.zip

Card image cap
Scrolly

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

scroll_Listbox.zip

Card image cap
SheetName

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

Card image cap
XLShortcut_EnableDisable

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

Card image cap
ChartMaxY + ChartMinY

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

Card image cap
Hand.cur

A cursor file type of Hand. used inside VBA to show hand when user hover over ...

hand.zip

Card image cap
Styles_DeleteNonStandard

Delete styles from an Excel workbook, any non-standard style will be deleted. ...

Card image cap
Page2Setting

Read content of an html online page into setting value in Excel sheet. ...

Card image cap
CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

Card image cap
ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

Card image cap
SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

Card image cap
RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...