ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Listbox question (https://www.excelbanter.com/excel-programming/274887-listbox-question.html)

Stuart[_5_]

Listbox question
 
If using AddItem to populate a listbox, and the item is a
long entry........Is there a way to force a carriage return,
rather than widen the listbox, please?

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003



Dick Kusleika

Listbox question
 
Stuart

I don't think you can have multiple lines for 1 entry in a listbox. With a
lot of coding you could put any continuation as a new item in the list. It
would take some work to piece it back together to use in any code. Another
option is to change the font of the listbox as a whole. Figure the largest
item that you are adding and adjust the font to accommodate that -
everything else will be smaller too.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Stuart" wrote in message
...
If using AddItem to populate a listbox, and the item is a
long entry........Is there a way to force a carriage return,
rather than widen the listbox, please?

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003






All times are GMT +1. The time now is 01:46 AM.

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