Search results 208

Card image cap
HMatchIf

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

Card image cap
BrowseWorkbook + BrowseWorkbook_Save

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

Card image cap
GetColumnName, ColumnName_XOffset

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

Card image cap
BrowseFolder

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

Card image cap
DeleteAllShapes

Delete all shapes in a sheet

Card image cap
GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

Card image cap
FrmAbout

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

FrmAbout.zip

Card image cap
FileDate_Formatted

Using FileDateTime to get file date

Card image cap
FindName

Finds a name in a workbook, returns true or false

Card image cap
Modify SQL table

SQL seams to have issues when we try to modify a table and preserving data, I ...

Card image cap
FindSheet

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

Card image cap
Multi-line Textbox focus bug

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