Share via

text Alignment justify on textbox value

biebien alhurairah 0 Reputation points
2023-09-05T05:04:14.5433333+00:00

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.
3,908 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,715 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Q&A Assist
    2023-09-05T05:04:14.5466667+00:00
    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.

    References:

    0 comments
  2. AllenXu-MSFT 20,286 Reputation points Microsoft Vendor
    2023-09-05T07:21:37.2333333+00:00

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.