+ Reply to Thread
Results 1 to 7 of 7

Bold items in Userfrom ListBox

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    Lebanon, Oregon
    MS-Off Ver
    Excel 2010
    Posts
    47

    Bold items in Userfrom ListBox

    I have a userfrom that gets the folders, subfolders and files from a user selected directory. this information is then listed in a listbox so the user can play with it more.

    I would like to make the folders & subfolders bold so that they stand out from the files. Is it possible to do this in a listbox or do I need a different tool?

    Thanks for the help.

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Bold items in Userfrom ListBox

    In the User Form, under the properties for the listbox, there is a font option. On the right hand side of the font option text box there is a button you can click to select bold font.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,446

    Re: Bold items in Userfrom ListBox

    Hi,

    Search for the word "font" on this web page. It tells how to do what you want.
    http://office.microsoft.com/en-us/ex...010236681.aspx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,646

    Re: Bold items in Userfrom ListBox

    You can't bold the individual items in a listbox.

    Perhaps you could try a ListView control instead.
    If posting code please use code tags, see here.

  5. #5
    Registered User
    Join Date
    11-14-2012
    Location
    Lebanon, Oregon
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Bold items in Userfrom ListBox

    Who would I do it with a listview?
    I have never used listview.

  6. #6
    Registered User
    Join Date
    08-26-2013
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Bold items in Userfrom ListBox

    Here are two approaches:

    1. Enter Design Mode
    Select the List Box
    Select Properties
    select Font
    Select Bold

    2. Use a Macro and enter:
    ListBox2.Font.Bold = True

    Of course change the name of ListBox2 to your needs.

  7. #7
    Registered User
    Join Date
    11-14-2012
    Location
    Lebanon, Oregon
    MS-Off Ver
    Excel 2010
    Posts
    47

    Re: Bold items in Userfrom ListBox

    Just to clerify what I am doing. I am doing this in a userfrom not in the spreadsheet itself, and I only want to bold some of the items in the listbox not all of the items.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Listbox, Need to change number of items in List (not the items)
    By Kalithro in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2013, 09:23 PM
  2. [SOLVED] Auto select items in a Listbox with items from another Listbox
    By perducci in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-22-2013, 04:45 PM
  3. Copy Selected items from multicolumn, multiselect listbox to another listbox
    By Willigb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2013, 11:27 AM
  4. Editing listbox items in Dblclick event freezes Excel unless mouse moves over listbox
    By muneebmansoor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-28-2013, 02:21 PM
  5. Transfer random listbox items to new listbox and then loop through selected items
    By narrowgate88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 05:58 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1