VBA-Excel 97 VBA that works only in Excel

Card image cap
ColumnName (newer version of ColumnName_XOffset)

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

Card image cap
DeleteAllShapes

Delete all shapes in a sheet

Card image cap
FixPath, IsThere, IsThere1

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

Card image cap
Col2Combo

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

Card image cap
Filesin_Coll + Filesin_Cells

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

Card image cap
FindName

Finds a name in a workbook, returns true or false

Card image cap
FindSheet

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

Card image cap
Multi-line Textbox focus bug

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

Card image cap
MoveDown + MoveUp

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

Card image cap
Paragraph2Line + Line2Paragraph

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

Card image cap
NameSilo_APICall_ListPrices

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

Card image cap
NameSilo_APICall_ListDomains

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