Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
Is it possible to format (alignment) of columns in a list box? we can assign column width, same way can we adjust alignment too? I have four column in a listbox like: Heading, amount, date, remarks. i would like to get the amount column right aligned, heading left and others centre? TIA Soniya |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi Soniya You can align all the columns of a ListBox with the TextAlign property, but you can't specify different alignments by column. -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Soniya" wrote in message ... Hi all, Is it possible to format (alignment) of columns in a list box? we can assign column width, same way can we adjust alignment too? I have four column in a listbox like: Heading, amount, date, remarks. i would like to get the amount column right aligned, heading left and others centre? TIA Soniya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Listbox format | Excel Discussion (Misc queries) | |||
Transferring from both columns of a listbox to another | Excel Discussion (Misc queries) | |||
format a listbox | Excel Discussion (Misc queries) | |||
Multi-columns in a ListBox | Excel Programming | |||
listbox format... | Excel Programming |