Return to VBA Code Examples

VBA Input Statement

Input Description

Returns the open stream of an Input or Binary file (String).

Input Syntax

The Input statement contains 2 arguments:

Number: The number of characters to return.

FileNumber: Valid file number.

Examples of Excel VBA Input Statement

To test the Input statement, create a text file “test.txt” on the D drive.(D:\test.txt) Assume that the content of the file is as following.

Please run the following code.

Then, the result will be as following.

VBA Coding Made Easy

Stop searching for VBA code online. Learn more about AutoMacro - A VBA Code Builder that allows beginners to code procedures from scratch with minimal coding knowledge and with many time-saving features for all users! vba save as

Learn More!