Components 68 Controls, objects and classes, also cells, sheets, workbooks in VBA-Excel

Card image cap
SendEmail_CDO

Sending an email using CDO object Can pass all needed variables including mail ...

Card image cap
ArrSort_2Arr

Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...

Card image cap
UserIP

Reads the website visitor IP

Card image cap
DetectEmailServers

Detects mail servers available by returning number of available mail servers ...

Card image cap
a href=#

Instead of using href="#", it is better to use href="javascript:void(0);" to ...

Card image cap
Application_OnStart

How to use Global.asa

Card image cap
ConfigWeb_Read

Reads a key value from certain section in Config.web Originally from ...

Card image cap
SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

Card image cap
XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

Card image cap
Page2Setting

Read content of an html online page into setting value in Excel sheet. ...

Card image cap
SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

Card image cap
CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...