VBA-Excel 329

Visual basic for applications that works only in Microsoft Excel, aka macros

Sorted from new to old.

GetColumnName, ColumnName_XOffset

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

2018Jun15

DeleteAllShapes

Delete all shapes in a sheet

2018Jun11

FixPath, IsThere, IsThere1 ...

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

2018Jun11

Col2Combo

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

2018Jun10

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

FindSheet

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

2018Jun7

Multi-line Textbox focus bug

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

2018Jun7

MoveDown + MoveUp

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

2018Jun2

Paragraph2Line + Line2Paragraph

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

2018Jun2

CutString

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

2018May29

NameSilo_APICall_ListPrices

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

2018May25

NameSilo_APICall_ListDomains

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

2018May25

NameSilo_APICall_AvailableBalance

Gets your balance in your NameSilo account using your own API

2018May23

CountColumnCells + CountColumnCells_Criteria

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

2018May23

GoToInternet

Opens webpage from within Excel, using default browser

2018May22

1 2 ...20 21