AutoSize Command

[Guest]

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.

 

[Guest]

Try fully qualifying the textbox.

frmName.textboxname.autosize=true

 

[Guest]

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