VBA 126

Visual Basic for Application (or macros) in most applications. Code here can also be used in VBA-Excel

Sorted from new to old.

DirsCombo_Read

Read directories in a specified folder into a combobox Needs FrmBr having Cbo1

2018Jun18

ScreenRes

Reads screen resolution, using IE this time, this one will get the active ...

2018Jun17

EnvVar_All

Read all Environment variables using EnvDir_All Or quickly get user folder, or ...

2018Jun17

Reversefile

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

2018Jun16

File_MostRecent

Getting most recent file in a folder

2018Jun16

WaitFor + ShellWait

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

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

ListBox_SelectedIndexes

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

2018Jun11

GenerateMemorablePassword

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

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

Filter_GotoItem

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

2018Jun7

ComputerSN

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

2018Jun6

FindIn1DArray

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

2018Jun6

Numbers in Textbox

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

2018Jun6

1 2 ...7 8