Search results 135

Sorted from new to old.

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

A is for Alpha

Military way to communicate letters in audio, for me I learned not all required, ...

2021Dec6

Tabindex in multipage

Tabindex and forcing focus to show in textbox if we have multipage control. ...

2021Dec6

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

2021Aug3

Navigate_IE

Reads HTML source page of a webpage, maynot work for heavy js pages, but works ...

2021May31

CutString8

Cuts a string from certain character to certain character with option of either ...

2021May29

Vertical page breaks

Change Vertical page breaks in Excel spreadsheet preparing to print Looks like ...

2021Feb24

Bootstra/386

A bootstrap v2, v3 or v4 theme to make webpages look like they are from the ...

2021Jan6

Pps vs ppsx

PowerPoint slideshow file types and differences in file size. Bottom line, if ...

2020Dec20

1 2 ...5 ...8 9