VBA 122

Visual Basic for Application (or macros) in most applications. Code here can also be used in VBA-Excel
  2. Languages
  3. VBA
Sorted from new to old.
Card image cap
File_MostRecent

Getting most recent file in a folder

2018Jun16
Card image cap
WaitFor + ShellWait

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

2018Jun16
Card image cap
HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15
Card image cap
BrowseFolder

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

2018Jun14
Card image cap
ListBox_SelectedIndexes

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

2018Jun11
Card image cap
GenerateMemorablePassword

Returns a random password that is easier to remember, such as BONES or LAMOT. ...

2018Jun11
Card image cap
FrmAbout

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

2018Jun11
Card image cap
FileDate_Formatted

Using FileDateTime to get file date

2018Jun10
Card image cap
Filter_GotoItem

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

2018Jun7
Card image cap
ComputerSN

Reads Serial number of the system, also can be used to return System name, ...

2018Jun6
Card image cap
FindIn1DArray

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

2018Jun6
Card image cap
Numbers in Textbox

Force textbox to accept numbers only. Needs adjustments to work on VB6

2018Jun6
Card image cap
RGB2Long

Converts Red, Green and Blue integers into RGB long value

2018Jun2
Card image cap
RoundUp

Rounds a number up, like Excel function RoundUP

2018Jun2
Card image cap
CutRightString

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

2018Jun2
Card image cap
CopyText2Clipboard

Copies text to clipboard using MSForms

2018May30
12...78