On Jun 16, 2:18*pm, Gord Dibben wrote:
Dom

I cannot replicate this in a textbox whether 2003 or 2007 versions.

I select a line out of a multiline string and hit right-align
icon.............all text aligns right.

Is this a new feature of Excel 2010?

Gord Dibben * * MS Excel MVP



On Thu, 16 Jun 2011 08:19:43 -0700 (PDT), Dom wrote:
But why then is it possible to right align a single line of text using
the EXCEL interface? *That is, I can select the line, hit the right
align button, and it is done. *It should be possible to do this in VBA..- Hide quoted text -

- Show quoted text -

I'm using 2007. Are we talking about the same thing? By textbox, I
mean the textbox shape, what you get from the INSERT ribbon. Not the
multiline text box you might see on a form. Also, you must have an
actual new line, not just text that has wrapped automatically. For
example, try "This is<CRa new line". You can make "This is" align
left, and "a new line" align right.