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

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
Printing in excel always comes out in bold even tho bold not on Scarlett50 Excel Discussion (Misc queries) 2 March 26th 10 02:39 PM
Alphabetically list of last names: BOLD, not bold Lerner Excel Discussion (Misc queries) 16 March 1st 09 07:46 PM
Alphabetically list of names BOLD and NOT bold Lerner Excel Discussion (Misc queries) 13 March 1st 09 02:37 PM
Join bold and non-bold text in one cell bkincaid Excel Discussion (Misc queries) 3 March 21st 06 12:58 AM
listbox.value not equal to listbox.list(listbox.listindex,0) ARB Excel Programming 0 October 22nd 03 12:46 AM


All times are GMT +1. The time now is 04:28 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"