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?

Microsoft 365 and Office | Development | Other
Microsoft 365 and Office | Excel | For business | Windows
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  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 No comments

  2. AllenXu-MSFT 24,986 Reputation points Moderator
    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 No comments

Your answer

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