Search results 663

Sorted from new to old.

MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17

Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

2018Jun16

Match3

Matching three values at the same time in three columns Just like Match the ...

2018Jun16

Match2

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16

Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...

2018Jun16

HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15

BrowseFolder

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

2018Jun14

OpenPassword + ClosePassword

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

2018Jun14

ListBox_SelectedIndexes

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

2018Jun11

FrmAbout

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

2018Jun11

FileDate_Formatted

Using FileDateTime to get file date

2018Jun10

Container Switcher

Using Classic ASP and cookies, allow users to personally choose between normal ...

2018Jun10

1FileDB

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

2018Jun9

Modify SQL table

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

2018Jun9

FindSheet

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

2018Jun7

Multi-line Textbox focus bug

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

2018Jun7

1 2 ...38 ...41 42