Search results 556

  2. Search results
  3. 39
Sorted from new to old.
Card image
BrowseWorkbook + BrowseWorkbook_Save

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

2018Jun16
Card image
WaitFor + ShellWait

Tell App to wait for number of seconds and Execute command and wait for it ...

2018Jun16
Card image
GetColumnName, ColumnName_XOffset

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

2018Jun15
Card image
Convert2SQLDate

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

2018Jun14
Card image
OpenPassword + ClosePassword

Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...

2018Jun14
Card image
ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

2018Jun11
Card image
FrmAbout

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

2018Jun11
Card image
FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11
Card image
Col2Combo

Reads everything in a column (starting from certain cell until blank cell is ...

2018Jun10
Card image
Filesin_Coll + Filesin_Cells

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

2018Jun10
Card image
FindName

Finds a name in a workbook, returns true or false

2018Jun10
Card image
1FileDB

DB in a File (One of my best library codes so far) Saves/Reads/Deletes certain ...

2018Jun9
Card image
Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

2018Jun8
Card image
FindSheet

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

2018Jun7
Card image
Multi-line Textbox focus bug

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

2018Jun7
Card image
Filter_GotoItem

Allow users to select from list box based on search terms. Have a text box and ...

2018Jun7
12...32...3435