Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 202
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 202
Default 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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Align Left and Right in Same Cell Sloth Excel Discussion (Misc queries) 6 April 25th 23 03:44 AM
Align the form to the top left Scott Excel Programming 5 August 8th 07 09:54 PM
Align to the left or to the right (or center) kaokao1 Excel Programming 2 June 6th 06 04:09 AM
Left align '$' and right align numbers? skeetley Excel Discussion (Misc queries) 1 October 21st 05 08:12 AM
Merge & align ..left? Joesph Excel Programming 1 March 6th 05 10:46 PM


All times are GMT +1. The time now is 10:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"