text Alignment justify on textbox value

biebien alhurairah 0 Reputation points

in vba excel textbox alignment just have 3 properties text alignment, left,center, right
how to make textbox value justify?

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,823 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,508 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Q&A Assist
    AI generated content. This question contains an answer created with AI from Q&A Assist. Learn more

    In VBA Excel, the TextBox control only supports left, center, and right alignment for text. It does not support justification.


    0 comments No comments

  2. AllenXu-MSFT 10,416 Reputation points Microsoft Vendor

    Hi @biebien alhurairah,

    The AI generated answer is right. Left, center and right alignment are supported in Textbox control. Justify alignment is not supported. I suggest you raising a thread in this feedback portal https://feedbackportal.microsoft.com/feedback/forum/c23f3b77-f01b-ec11-b6e7-0022481f8472 for Excel. The Excel product team actively monitors user ideas there.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments