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.

  • royUK

    Changed the title of the thread from “Auto created Text box Resizing Based on Text length and Width” to “Auto created Text File Resizing Based on Text length and Width”.