Search results 225

Sorted from new to old.

ANBS controls

Set of functions to generate Bootstrap controls as strings. Controls available ...

2018Jun24

GetPapa

Gets folder name of a page using FSO

2018Jun24

LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

2018Jun24

RowsCount

Get total number of rows for a certain worksheet in certain workbook workbook ...

2018Jun22

CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

2018Jun22

ASCII_Read + ASCII_Save

Reads and saves text file giving its full name Used a lot in my websites, very ...

2018Jun21

DirsCombo_Read

Read directories in a specified folder into a combobox Needs FrmBr having Cbo1

2018Jun18

CellRead

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...

2018Jun16

Match2

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16

HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

2018Jun16

BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

2018Jun16

GetColumnName, ColumnName_XOffset

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

2018Jun15

BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

2018Jun14

DeleteAllShapes

Delete all shapes in a sheet

2018Jun11

GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

2018Jun11

FrmAbout

Display a string in a Userform as 'About' window, can display string or file by ...

2018Jun11

1 2 ...12 ...14 15