Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alignment and format in listbox columns
the listbox control provided in both the forms toolbar and control toolbox
toolbar do not offer control of column alignment or numberformatting. When you load the array, you need to load it with a formatted string. You would need to simulate alignment with embedded spaces. -- Regards, Tom Ogilvy "Claus" wrote in message ... Hi I need to control the alignment and format of colums in a listbox that i fill using array. I need columns 1, 4,5,6 and 7 to be right aligned I need columns 1, 4, 5 and 6 to be formatted like this #.###,## i've done like this with column 1 in the code: MyArray(Rk, 0) = Format(Selection.Value, "##,#0.00") I need column 7 formatted as percentage. See the attached picture. Hoping for help. Claus Persson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format, Cells, Alignment. | Excel Discussion (Misc queries) | |||
Format Axis Alignment | Charts and Charting in Excel | |||
Data Alignment in columns | Excel Discussion (Misc queries) | |||
Q: find range, listbox - format and fit columns | Excel Programming | |||
Format columns in a ListBox? | Excel Programming |