Search results 220

Sorted from new to old.

IsEven + IsOdd

Returns True if integer is even by using IsEven While IsOdd, will returns True ...

2018Sep27

Posts Per Year

Create summary list If you have SQL table named Table_Name, with DateAdded ...

2018Sep22

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

SetAttr

Sets an attribute to file or folder Needs to have variables defined as you see ...

2018Aug16

ChartMaxY + ChartMinY

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

2018Aug16

GetAttr

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

2018Aug12

CopyRange_NoClipboard

Copies range without using clipboard. Applies formats into a cell (or range) ...

2018Aug10

ApplyValidation_DropDown

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

2018Aug10

CellSave_Hyperlink

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

2018Aug9

FixPath_Word

Fixes the path for a given folder, PC or Mac by adding separator only if ...

2018Aug9

UserSign

Returns someones astrology sign using their birthday in m/dd/yyyy or m/dd/yy ...

2018Aug8

CutString_Words_Left + CutString_Words_Mid

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

2018Aug8

Prn

Printout into page, along with additional function to decide where to put the ...

2018Aug5

List_Load + List_Save

Loads/Saves items from/to text file to/from listbox Also has simple adding and ...

2018Jul26

sortArray

Sort an array of Numeric values, simple straightforward Edit v3 2021-09-21: ...

2018Jul25

1 2 ...11 ...13 14