View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CWillis
 
Posts: n/a
Default AutoSize Command

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.