ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Bold in Listbox (https://www.excelbanter.com/excel-programming/302839-re-bold-listbox.html)

Jake Marx[_3_]

Bold in Listbox
 
Hi Lacklustre,

ListBoxes don't give you much flexibility when it comes to formatting. You could try a ListView control instead - much more powerful and flexible. If you right-click the controls toolbox and select Additional Controls, you may find it listed as "Microsoft ListView Control".

--
Jake Marx
MS MVP - Excel
www.longhead.com


"Lacklustre" wrote:

I am adding items to a listbox but cannot seem to bold just one line item. If i use the bold.value it applies it to the entire listbox. A snippet of the code is below.

Worksheets("Proposal").ListBox3.AddItem Worksheets("Proposal").Range("d11").Value
Worksheets("Proposal").ListBox3.AddItem ""
Worksheets("Proposal").ListBox3.AddItem Worksheets("Proposal").Range("c11").Value


I want to make the third entry (including the blank line) to be bold but the first one not. IS this possible ?



All times are GMT +1. The time now is 11:46 PM.

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