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

Card image cap
Frm3

Browser window in a userform Just add Frm3 and call Frm3.Frm3_OpenWeb passing ...

Frm3.zip

Card image cap
IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

Card image cap
Between_HTMLtag

Returns the full text found between HTML tag open and close by either and index ...

Card image cap
O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

Card image cap
List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

Card image cap
FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

frmRename.zip

Card image cap
ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

Card image cap
LXFormat

Formats a number found at end of string to have additional leading zeros to ...

Card image cap
Excel user name

Get application user name or change it Originally from

Card image cap
SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

Card image cap
Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

Card image cap
ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...