Search results 231

Sorted from new to old.
Card image
BrowseWorkbook + BrowseWorkbook_Save

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

Card image
GetColumnName, ColumnName_XOffset

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

Card image
BrowseFolder

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

Card image
DeleteAllShapes

Delete all shapes in a sheet

Card image
GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

Card image
FrmAbout

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

Card image
FileDate_Formatted

Using FileDateTime to get file date

Card image
FindName

Finds a name in a workbook, returns true or false

Card image
Modify SQL table

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

Card image
FindSheet

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

Card image
Multi-line Textbox focus bug

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

Card image
ComputerSN

Reads Serial number of the system, also can be used to return System name, ...

Card image
MoveDown + MoveUp

Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...

Card image
DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

Card image
CutString3

Cuts string from a larger one based on a specific separator.

Card image
CutString3

Cuts a string from a larger one using separators.
Ex, CutString3("Will ...