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.
|