Search results 243

Sorted from new to old.

ANmaVBATemplate

Template to be used for any new tools, having... D sheet, WelcomeSheet, code ...

2018Jul26

CustomExcelMenu - FaceIDs

How to create custom Excel menu, this one shows the IDs and icons of 20 icons, ...

2018Jul19

URLs2Anchors

All links found inside a string into anchor (< a href=...) BUG!: Currently ...

2018Jul17

myURLDecode

Decode a URL, opposite of Server.URLEncode

2018Jul15

RemoveHTMLTags

Remove HTML tags from a string, note, this won't handle html encoding.

2018Jul15

Win10 User Folders

I hate it when Microsoft takes back some controls it already gave to users, one ...

2018Jul9

Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9

FaceIDs

Excel menu icons and icon ids (named FaceIDs) used when yu create toolbars and ...

2018Jul9

XLThumbView

Showing thumbnails inside sheet and enlarging each when click

2018Jul9

DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

2018Jul7

oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

2018Jul6

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

DeleteAllFiles

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

2018Jun30

Numeric-only textbox

Allow only Currency into textbox, text box will allow only nnnn.nn where n=1 ...

2018Jun27

Distance_Calc_fromString

Calculate distance between two points (Latitude, Longitude) LatLon1 and ...

2018Jun27

1 2 ...14 15 16