Search results 534

Sorted from new to old.

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

ChartMaxY + ChartMinY

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

2018Aug16

Hand.cur

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

2018Aug14

Styles_DeleteNonStandard

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

2018Aug12

GetAttr

Reads attributes of a file using FSO. Return will be a string of RHSA ...

2018Aug12

Page2Setting

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

2018Aug12

Bootstrap Modal variables

Bootstrap link to pass variables to modal content Used to build list of links ...

2018Aug10

RandomImage

Gets a random image from a folder of files, passed as an unMapPathed (HTML) ...

2018Aug10

Pagination call

How to read certain page from SQL table Originally from from http://social. ...

2018Aug10

RunFromShared

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

2018Aug9

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

2018Aug9

PCase (ProperCase)

Just like UCase and LCase, ProperCase (or PCase) will capitalize 1st letter of ...

2018Aug8

FoldersIn5

Creates list of subfolders and subfolders of each down to 5 levels Folder ...

2018Aug8

CutString_Words_Left + CutString_Words_Mid

Cuts the left or Middle part of string without breaking words Can specify ...

2018Aug8

1 2 ...25 ...33 34