Search results 154

Sorted from new to old.

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

Frm3

Browser window in a userform Just add Frm3 and call Frm3.Frm3_OpenWeb passing ...

2023Jul30

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

2023Jul7

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

Windows7 css

A CSS to format website as Windows 7. From

2023May30

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

ForegroundColor

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

2023May5

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18

Antispam - Hiding textbox

Anti spam email web form idea.

2022Nov14

Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

1 2 3 ...9 10