Search results 61

  2. Search results
  3. old value
Sorted from new to old.
Card image
Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

2025Aug7
Card image
ANmaRemoveMultiSpace

Removes multiple spaces from within string, those are up to 16 spaces that ...

2025May16
Card image
MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

2025May7
Card image
VBInstr_SpaceFriends_BetweenHTMLTags

Searches for string inside string with multiple possibilities, returns ...

2025Mar13
Card image
FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

2024Nov25
Card image
RegExPatternMatch

Checks string against pattern using RegEx (VBScript.RegExp). The pattern ...

2024Nov10
Card image
Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

2024Sep3
Card image
Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

2024Aug20
Card image
HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

2024Aug7
Card image
Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

2024Jul23
Card image
OrderedList in Arabic Alphabet

Using Arabic in ordered list in HTML, as Abjad or Alphabet. Was playing with ...

2024Feb25
Card image
VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

2024Jan24
Card image
SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

2024Jan8
Card image
SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29
Card image
ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27
Card image
XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

2023Nov26
1234