Search results 185

Sorted from new to old.

ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

2023May5

NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

2023May3

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

2023Jan6

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

DateDiff_En

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

2022Mar3

Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

2022Mar3

AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23

Frm5Textbox

Shows a text in textbox as separate window Caller can modify size of textbox, ...

2022Feb22

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

CopyFiles

Copies files from list of files into a folder. Uses list of files with ...

2022Feb3

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

1 2 ...4 ...11 12