| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reducing a List by Eliminating Entries from Another List | Excel Discussion (Misc queries) | |||
| how to identify unique list of 200 random entries from a list of 3 | Excel Worksheet Functions | |||
| make a list from another list ignoring duplicate entries from orig | Excel Worksheet Functions | |||
| How justify list of words? | Excel Discussion (Misc queries) | |||
| Removing all entries in one list that appear in a different list | Excel Discussion (Misc queries) | |||
Linear Mode
