ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

LXFormat

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

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

NumberDigitImage

Creates list of images to represents a number. Basically multiple < img > tags ...

NumberDigitImage.zip

Convert_Dash_to_Zero

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

Max + Min + Min_No0s

Calculate maximum of array of numbers or Minimum of array of numbers Also, ...

HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...

pd

Format a number with total number of digits I used it to format a date as ...

RandomHelloACM

Generate random using web service into ASP variable. With help of PHP, we now ...

RandomHelloACM.zip

Floor

Rounding a number to nearest integer closest to zero.
Equivalent to Excel ...