ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   align left and right in listbox (https://www.excelbanter.com/excel-programming/397454-align-left-right-listbox.html)

dennis

align left and right in listbox
 
I'm filling a listbox with descriptions and amounts. I want the descriptions
to be aligned left and the amounts aligned right. Can this be done in a
listbox?

Tim Williams

align left and right in listbox
 
With a single column the best you could do is format the list in a
non-proportional font and padd out the items with spaces.

Tim


"Dennis" wrote in message
...
I'm filling a listbox with descriptions and amounts. I want the
descriptions
to be aligned left and the amounts aligned right. Can this be done in a
listbox?




dennis

align left and right in listbox
 
Tim, this is a multicolumn listbox. So I assume you cannot do this with
Excel's listbox?

Please let me know,

Dennis

"Tim Williams" wrote:

With a single column the best you could do is format the list in a
non-proportional font and padd out the items with spaces.

Tim


"Dennis" wrote in message
...
I'm filling a listbox with descriptions and amounts. I want the
descriptions
to be aligned left and the amounts aligned right. Can this be done in a
listbox?






All times are GMT +1. The time now is 09:12 AM.

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