VBA textBox columns

Question

How can I set columns number for the textbox in VBA for Excel? (excel located -> format shape -> text box -> columns). I have tried to look all over internet and office help but i can find only read only property column on the text box. I use Office 2010

Ken · Accepted Answer · 2014-03-17 13:57:07Z

1

I just recorded a macro, and it came up with this:

    ActiveSheet.Shapes.Range(Array("TextBox 1")).Select
    Selection.ShapeRange.TextFrame2.Column.Number = 2

answered Mar 17, 2014 at 13:57

Ken

1,1661 gold badge6 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AjV Jsy · Accepted Answer · 2015-01-27 12:47:11Z

0

After a cut-n-paste from a Word doc, I found I had a text box called "Text Box 1". One line (demo for the immediate window) shows the number of columns :
? Sheets(1).Shapes("Text Box 1").TextFrame2.Column.Number

and FWIW the text in the box is :
? Sheets(1).Shapes("Text Box 1").TextFrame.Characters.Text

answered Jan 27, 2015 at 12:47

AjV Jsy

6,1154 gold badges39 silver badges30 bronze badges

Collectives™ on Stack Overflow

VBA textBox columns

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related