Auto created Text File Resizing Based on Text length and Width

  • Hi,

    I am using the below code to create the text box based on cell data.

    But now I want this text box to automatically size with the text length and width.

    Can It be possible to do it by using VBA?

    Thanks in Advance.

  • Thanks, Royuk.

    Yes, Actually it is a Text file. I want that the text file opens based on the text length and width in it.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!