VBA-Excel 281 Visual basic for applications that works only in Microsoft Excel, aka macros
User-Defined Formatting
Apply special Conditional Formatting, color cells based on their values. This ...
Open different Filestypes
Populate list of filetypes in Application.GetOpenFilename method. This command ...
Permission Denied error
Issue: Trying to copy file (Using VB command FileCopy) while that file was ...
TreeView
A plain pure VBA Treeview control to be used inside Excel (official link has ...
treeviewexcel025.zip
Listbox height changing issue
Listbox in Excel sometimes have issue adjusting height to items added inside, ...
Listbox height changing issue.zip
Scrolly
Scroll a listbox Using Right-Drag. (Something VBA in Excel lacks) You might ...
scroll_Listbox.zip
XLShortcut_EnableDisable
Disables or Enables certain Excel built-in shortcut. Code has example on how ...
ChartMaxY + ChartMinY
Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...