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

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

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

"Jim Zeeb" wrote:

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

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

"Jim Zeeb" wrote:

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

from the properties window of the listbox select textalign and then select #3
--
Jim at Eagle


"Jim Zeeb" wrote:

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