-->

View a macro's code. If you want to learn more about how macro coding works, you can open the code of any macro you've created and tinker with it: Click the Macros button in the Developer tab. Click the macro you want to view. Click the Edit button. View your macro code in the Visual Basic code editing window. Add the following code lines: Do Until EOF (1) Line Input #1, textline. Text = text & textline. Note: until the end of the file (EOF), Excel VBA reads a single line from the file and assigns it to textline. We use the & operator to concatenate (join) all the single lines and store it in the variable text. You can use the ImportExportText macro action to import or export text between the current Access database (.mdb or.accdb) and a text file. You can also link the data in a text file to the current Access database. This macro makes use of the Draft ShapeString tool to create a text line placed in different circular orientations, including circumferential and helical (in the fashion of a Trajan Column). It can also be used to create a clock face with Arabic numerals 1, 2, 3, etc., or Roman numerals I, II, III, etc.

Returns the formatted text for the specified object. Read-only String.

Syntax

expression.Text

expression A variable that represents a Range object.

Remarks

The Text property is most often used for a range of one cell. If the range includes more than one cell, the Text property returns Null, except when all the cells in the range have identical contents and formats.

If the contents of the cell is wider than the width available for display, the Text property will modify the displayed value.

Property Differences Example

This example illustrates the difference between the Text and Value properties of cells that contain formatted numbers.

Text Width Differences

Cells containing numeric values may have their displayed value modified when the column isn't wide enough. The example below shows this using two columns. The first column is wide enough to display the values. A format is applied and then a value entered showing the full value. The second column has its width reduced such that when the cells are copied over it is too narrow causing the displayed value to be moified.

Support and feedback

Text Macro Mac

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

Text Macro Program

If you want to create a text macro from existing text,select the text in the document.

Choose New Macro from the Text Macros panel menu, orclick the New Macro button inthe Text Macros panel.

Enter a macro code in the Macro Code text box. Note thatmacro codes are case-sensitive.

For Macro Text, type the text string that you want enteredwhen you activate the text macro.

To include text attributes from the existing text wheninserting or swapping macro text, select Remember Text Attributes.

By default, inserted or swapped macro text uses the styleattributes of the destination paragraph.

To assign a keyboard shortcut for activating the macro,place the cursor in the Macro Key Shortcut text box, andpress the keys you want to use for the shortcut.

Shortcuts are especially useful if you turn off AutomaticallySwap Macro Text in the Text Macros panel.

If the keyboardshortcut you want to assign to the macro is already assigned to anotherfunction, the alert symbol appears at the bottom of the dialog boxwith the message “Currently Assigned To: [function].”If you choose to assign the keyboard shortcut to the macro, theprevious keyboard shortcut function is overridden.