Arrays To Columns in Text Box

Category:
Forms and Controls
Type:
Snippets
Difficulty:
Beginning
Author:
Ethan

Version Compatibility:

More information:
This code shows how to use arrays to put columns in text boxes. The code preloads data to the array for this example but you can enter data in the first column until you reach a predetermined row then then redim preserve column 2,3.... as needed. This code uses the vbtab constant to set the next column, and includes code to set tab stops to ensure the columns are evenly aligned. Paste the code into a new project with a text box set to multiline = true.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: