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.

--
Regards,
Tom Ogilvy

"Jim Zeeb" wrote in message
...
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