I have created Macro based Excel sheet. I have designed a form with Active X Text Box for entering Comments.

Using Active X box was needed to give users feel and tighten them to use fixed width (scrollable height).

Now user can enter huge data in that text box with vertical scrollable height but when sheet is Printed it should Print the text box with all entered data(basically Expand the Active X box vertically to fit the text content.

The Text box properties has Attributes to Auto size, auto load, Print Object etc but not sure what to do if we need Print Object with Expanded height to autofit text.

Please let me know how this can be achieved. Attachment gives brief overview of system

Hi,

According to your description, we might try to add a Change event to correct it, like this:

Private Sub TextBox1_Change()
TextBox1.Width = 125
End Sub

Please check if it is help for you, reference:

http://answers.microsoft.com/en-us/office/forum/office_2010-excel/activex-textbox-autosize-bug/5b8c86cc-b298-4bb9-88a4-01e2ed0db24d

Regards,