Search results 59

Sorted from new to old.
Card image
Bootstrap Modal variables

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

Card image
ApplyValidation_DropDown

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

Card image
PCase (ProperCase)

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

Card image
FoldersIn5

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

Card image
Ask4Folder

Asks user for a folder, starting with certain folder

Card image
RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

Card image
getDaysInMonth

Gets number of days in a certain month

Card image
CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

Card image
ServerUptime

Return how long the computer has been running. Return format is dd:hh:mm:ss ...

Card image
IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

Card image
SwapDate

Changes date format from US to International or from international to US. ...

Card image
TimeRound

Rounds the number of minutes to the nearest quarter of half like 4:32 to 4:30 ...

Card image
GetTimeZone

Get local timezone Uses w32tm / tz dos command in command prompt Using ...

Card image
HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

Card image
ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

Card image
ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...