Search results 547

Sorted from new to old.

MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16

WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

2018Jun16

WaitFor + ShellWait

Tell App to wait for number of seconds and Execute command and wait for it ...

2018Jun16

Crypt128

Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...

2018Jun14

DeleteAllShapes

Delete all shapes in a sheet

2018Jun11

FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

Filesin_Coll + Filesin_Cells

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

2018Jun10

FindName

Finds a name in a workbook, returns true or false

2018Jun10

1FileDB

DB in a File (One of my best library codes so far) Saves/Reads/Deletes certain ...

2018Jun9

FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

Numbers in Textbox

Force textbox to accept numbers only. Needs adjustments to work on VB6

2018Jun6

Crypt512

To encrypt or decrypt any string ' Strii is the required text to protect ' ...

2018Jun2

StringFlip

Flips a string, right-to-left, and if passed again, will flip it back Can be ...

2018Jun2

RemoveHTML

Removes HTML code Basically all tags expected and listed below There is a ...

2018May26

CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23

1 2 ...34 35