Listbox Column RightAlign with RowSource.ExcelRange

[Guest]

I have a ListBox that is tied to an excel range using RowSource. I saw a
post here that had a subroutine that Aligned a ListBox column. The problem
is that it used the .List(row,col) property to change the listbox cell with
the aligned data. I'm getting an "Access Denied" error on trying to set the
..List property. I'm pretty sure this is because it is linked to the Excel
rows.

Is there an alternate method to right-aligning data in a ListBox column
linked to an Excel Range. The data in the Excel range is numeric and
formatted using Excel formatting.

inTHANKSadvance

 

[Tom Ogilvy]

Not sure what you saw, but to the best of my knowledge, there are no
commands for aligning a column in a listbox. the best you can do is pad
the data to achieve the effect.

 

[Guest]

Hi Jim,

I am not sure I understand your problem. The display of the List box is
already aligned into separate columns when you provide a row source property.
For instance set the row source to Sheet1!J4:K8 and the display will be
aligned into two columns. Am I missing something?

Alok Joshi

 

[Guest]

Jim,
Ignore my earlier post. I re-read your question and it is clear to me what
your problem is. I do not have a solution.
Alok Joshi

 

[Guest]

from the properties window of the listbox select textalign and then select #3