![]() |
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? |
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? |
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? |
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