VBA-Excel 326

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

Sorted from new to old.

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

Navigate

Downloads a certain page source into a variable, full content in HTML, using ...

2018May22

GetPapa, GetPapa_URL, GetPapa_Sep, GetSon, GetSon_

Gets that parent folder name giving a full path, or gets the child folder, Can ...

2018May22

DownloadFile

Download a file from URL from inside Excel into certain path, returns blank if ...

2018May22

1 2 ...20 21