PrettyPath

Formats a path for use in user displays, trim it beautifly. PrettyPath is ...

IsValidUTF8 + DecodeUTF8 + EncodeUTF8

Checks UTF8, or convert to/from UTF8. Simple functions to convert the first 256 ...

Scrolly

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

scroll_Listbox.zip

ApplyValidation_DropDown

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

FoldersIn5

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

WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

WorkbookOpenAsk_ANmar

Asks user to browse to a file and return full path and file name if they do, ...

FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

MoveDown + MoveUp

Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...

VBA Progressbar (Frm73)

Progress bar Frm73 or just simple message Zip file contains .frm and .frx ...

Frm73.zip

Recurse and Rename

Recurses down a directory tree and renames files