Search results 54

Sorted from new to old.

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

Register OCX in 64 and 32 bit

Copy and register ocx using cmd (DOS batch) in Windows 32bit and 64bit.

2020Feb9

Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

2020Feb7

ProtectString + UnProtectString

Protects or unprotects a string giving a password Using XorD and similar to ...

2020Jan10

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

Awesome Bootstrap Checkboxes

Bootstrap checkbox with font-awesome (BS-FA Checkbox) From

2019Jul30

HeadingZeros Remove and Add

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

2019May31

ANmaTimeline

Creates HTML timeline dynamically, using Bootstrap 4.0 and FontAwesome 5, in a ...

2018Aug26

Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

2018Jun30

DeleteAllFiles

Delete All Files in a Folder. Needs a reference to Microsoft Scripting Runtime

2018Jun30

DownloadFile_User

Downloads file to user, asking user where to save or to open downloaded file

2018Jun30

LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

2018Jun24

CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

2018Jun22

InvertColor

Converts color into its negative value, as in "e4f15a" into "1C0FA6"

2018Jun20

1 2 3 4