LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 70
Default Userform listbox font color


I have a multicolumn listbox on a userform in an Excel 2007 spreadsheet that
populates store numbers and group names based on a group name selected from a
combobox. All the information is obtained from named ranges on a worksheet.
I would like to have the listbox display the store numbers of new stores
(from another column on the worksheet where values are "Yes" or "No") in a
different font color than stores that are not new. Is this possible?

TIA,

Ken
 
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
Conditional Format for font color using font color Jim Excel Worksheet Functions 2 August 29th 09 11:54 AM
Font color in userform controls. TUNGANA KURMA RAJU Excel Programming 1 May 22nd 08 04:49 AM
color font for listbox column [email protected] Excel Programming 1 October 3rd 07 04:47 PM
userform listbox cannot get listbox.value to transfer back to main sub [email protected] Excel Programming 1 May 17th 06 09:44 PM
Userform-Change textbox color and font based on input in other tex Neal Excel Programming 2 July 22nd 05 12:16 AM


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

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

About Us

"It's about Microsoft Excel"