Search results 397

  2. Search results
  3. If
Sorted from new to old.
Card image cap
GetColumnName, ColumnName_XOffset

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

2018Jun15
Card image cap
Convert2SQLDate

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

2018Jun14
Card image cap
BrowseFolder

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

2018Jun14
Card image cap
Crypt128

Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...

2018Jun14
Card image cap
ListBox_SelectedIndexes

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

2018Jun11
Card image cap
DeleteAllShapes

Delete all shapes in a sheet

2018Jun11
Card image cap
GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

2018Jun11
Card image cap
Filesin_Coll + Filesin_Cells

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

2018Jun10
Card image cap
FindName

Finds a name in a workbook, returns true or false

2018Jun10
Card image cap
Modify SQL table

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

2018Jun9
Card image cap
FindSheet

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

2018Jun7
Card image cap
Multi-line Textbox focus bug

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

2018Jun7
Card image cap
FindIn1DArray

Returns 1 if an item found in array, 0 if not

2018Jun6
Card image cap
MoveDown + MoveUp

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

2018Jun2
Card image cap
Time2Real

Converts TIME code to number HH:MM to xx.xx As in 10:15 to 10.25, 13:30 to 13.5

2018Jun2
Card image cap
Paragraph2Line + Line2Paragraph

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...

2018Jun2
12...232425