Search results 409

Sorted from new to old.
Card image
ListBox_SelectedIndexes

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

Card image
DeleteAllShapes

Delete all shapes in a sheet

Card image
GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

Card image
Filesin_Coll + Filesin_Cells

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

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
FindIn1DArray

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

Card image
MoveDown + MoveUp

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

Card image
Time2Real

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

Card image
Paragraph2Line + Line2Paragraph

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

Card image
Crypt512

To encrypt or decrypt any string ' Strii is the required text to protect ' ...

Card image
StringFlip

Flips a string, right-to-left, and if passed again, will flip it back Can be ...

Card image
CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

Card image
DB_Setting1List + DB_Setting1List_NameValue

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