Search results 416

Sorted from new to old.

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

XLThumbView

Showing thumbnails inside sheet and enlarging each when click

2018Jul9

IIF

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

2018Jul7

oShellRun1

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

2018Jul6

Num2En

Convert number to English words, convert 450 to 4 hundreds and fifty dollars

2018Jul6

[TAB] inside textarea

Allow textarea's to accept TAB key (ASCII code 63) Could use some enhancements, ...

2018Jul6

Limit Textarea

Show number of characters in a textarea and limit if it goes greater than ...

2018Jul5

ServerVar

Get value of Server variable by passing variable name aVar can be any of these ...

2018Jul4

Capitalize

This function capitalizes first letter of each of the words in a sentence, ...

2018Jul3

XorC

Simple small function to Encrypt or Decrypt a string Test_XorC is for testing ...

2018Jul1

SharePointURL2Path + Path2SharePointURL

Converts SharePoint URL to regular folder path and the other way, giving the ...

2018Jun30

DeleteAllFiles

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

2018Jun30

WordsOf + Words_Len

WordsOf to create list of words from a block after converting every special ...

2018Jun28

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 ...23 ...25 26