ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Right Justify List Box Entries (https://www.excelbanter.com/excel-programming/321222-right-justify-list-box-entries.html)

Dandog

Right Justify List Box Entries
 
I have a multi column list box that is filled through an array from my code.

Several columns contain numerical data which I want right justified within
the column at the time I write the array. Does anyone have any idea how to do
this?

Tom Ogilvy

Right Justify List Box Entries
 
You would have to pad the data with spaces.

--
Regards,
Tom Ogilvy

"Dandog" wrote in message
...
I have a multi column list box that is filled through an array from my

code.

Several columns contain numerical data which I want right justified within
the column at the time I write the array. Does anyone have any idea how to

do
this?




Dandog

Right Justify List Box Entries
 
Tom - I thought you of all people would have come through with a beautifully
crafted technical answer :-).

I think I'll stick with the defaults if there is no way around it other than
inserting spaces. It is about time the engineers at MS thought about the
presentational aspects of some of their forms controls!

Thanks for the response.

"Tom Ogilvy" wrote:

You would have to pad the data with spaces.

--
Regards,
Tom Ogilvy

"Dandog" wrote in message
...
I have a multi column list box that is filled through an array from my

code.

Several columns contain numerical data which I want right justified within
the column at the time I write the array. Does anyone have any idea how to

do
this?





Jake Marx[_3_]

Right Justify List Box Entries
 
Dandog,

You could use a ListView control, which allows for column alignment, native
sorting, and individually-formatted rows.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Dandog wrote:
Tom - I thought you of all people would have come through with a
beautifully crafted technical answer :-).

I think I'll stick with the defaults if there is no way around it
other than inserting spaces. It is about time the engineers at MS
thought about the presentational aspects of some of their forms
controls!

Thanks for the response.

"Tom Ogilvy" wrote:

You would have to pad the data with spaces.

--
Regards,
Tom Ogilvy

"Dandog" wrote in message
...
I have a multi column list box that is filled through an array from
my code.

Several columns contain numerical data which I want right justified
within the column at the time I write the array. Does anyone have
any idea how to do this?




All times are GMT +1. The time now is 04:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com