I am trying to auto size a text box using a macro. The text box was created
from the control toolbar if that makes a difference. Microsoft help says the
command is: object.AutoSize = True

They give the example of: TextBox1.AutoSize = True

Here is the portion of my code that I wrote that is currently giving me the
problem:

Selection.Name = "SummScrollingTextBox"
Selection.AutoSize = True

Excel gives the following error:

"Object doesn't support this property or method"

Any ideas? Thanks.

Try fully qualifying the textbox.

frmName.textboxname.autosize=true
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"CWillis" wrote:

I am trying to auto size a text box using a macro. The text box was created
from the control toolbar if that makes a difference. Microsoft help says the
command is: object.AutoSize = True

They give the example of: TextBox1.AutoSize = True

Here is the portion of my code that I wrote that is currently giving me the
problem:

Selection.Name = "SummScrollingTextBox"
Selection.AutoSize = True

Excel gives the following error:

"Object doesn't support this property or method"

Any ideas? Thanks.

Yep, it works now. (That won't last long.) Thank you!

"galimi" wrote:

Try fully qualifying the textbox.

frmName.textboxname.autosize=true
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"CWillis" wrote:

I am trying to auto size a text box using a macro. The text box was created
from the control toolbar if that makes a difference. Microsoft help says the
command is: object.AutoSize = True

They give the example of: TextBox1.AutoSize = True

Here is the portion of my code that I wrote that is currently giving me the
problem:

Selection.Name = "SummScrollingTextBox"
Selection.AutoSize = True

Excel gives the following error:

"Object doesn't support this property or method"

Any ideas? Thanks.