VBA Alignment of text within a textbox

Question

I wants to know got any way to display a text inside the textbox together with align left and right. The textbox property just only left or right. Example:

enter image description here

Use a fixed width (non-proportional) font and right pad the first value with spaces to a fixed length. — Tim Williams
– Tim Williams, Commented Feb 10, 2014 at 6:40
why don't you just use 2 textboxes. or is it part of your requirement to only use 1? — L42
– L42, Commented Feb 10, 2014 at 9:12
Any idea how to fixed the length? Because i will have the scroll bar,the filename and the date should be in the same line. — whywhy
– whywhy, Commented Feb 10, 2014 at 14:47

Sagar · Accepted Answer · 2017-04-03 08:52:32Z

1

I have been trying to align amount with 3 decimal places in the right of a text box. The string variable I use is addnreport.

I used a temporary string StrX which I RSet (Right Pad) In atext editor, it shows up as expected but in the Text Box, the values on the extreme right seem to be centre aligned no matter what you do.

addnreport = addnreport & acc & vbTab & month & vbTab & "PL" 
            RSet StrX = (Format(Round(amount, 3), "#,###,###,##0.000"))
            addnreport = addnreport & StrX & vbCrLf

answered Apr 3, 2017 at 8:52

Sagar

1911 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Deddy H · Accepted Answer · 2014-02-10 05:29:38Z

0

You can try add tab char for this,

set default textbox alignment to left,
in code behind add first word
in code behind add tab char
in code behind add second word
display it in your textbox

hope it work

answered Feb 10, 2014 at 5:29

Deddy H

3522 gold badges7 silver badges19 bronze badges

Collectives™ on Stack Overflow

VBA Alignment of text within a textbox

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related