VBA-Excel 332

Visual basic for applications that works only in Microsoft Excel, aka macros
Sorted from new to old.
Card image
MatchIf (aka VMatchIf)

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

Card image
WorkbookOpen_ANmar

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

Card image
BrowseWorkbook + BrowseWorkbook_Save

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

Card image
GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

Card image
DeleteAllShapes

Delete all shapes in a sheet

Card image
FixPath, IsThere, IsThere1 ...

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

Card image
Col2Combo

Reads everything in a column (starting from certain cell until blank cell is ...

Card image
Filesin_Coll + Filesin_Cells

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

Card image
FindName

Finds a name in a workbook, returns true or false

Card image
FindSheet

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

Card image
Multi-line Textbox focus bug

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

Card image
MoveDown + MoveUp

Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...

Card image
Paragraph2Line + Line2Paragraph

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...

Card image
CutString

Cuts a string from certain char till certain char, can be used to cut left, ...

Card image
NameSilo_APICall_ListPrices

Downloads list of domains and prices for register, renew or transfer into ...

Card image
NameSilo_APICall_ListDomains

Downloads list of registered Domains in your account from NameSilo.com using ...