Results 1 to 10 of 10

Macro to find bold cells and add to combo box

Threaded View

  1. #1
    Registered User
    Join Date
    12-06-2012
    Location
    Oxford, England
    MS-Off Ver
    Excel 2010
    Posts
    11

    Macro to find bold cells and add to combo box

    Hi guys, my code would need to look in column B from row 5 for cells that have bold text and each cell value would become an option in the combo box list from the user form.

    here's my code as I tried to adapt but if I don't specify a limit it will crash even if the column is not formatted as bold.
    'Sets the list for Select Category combobox:
        Dim Search As Range
        For Each Search In Range("B5:B19")
            If Search.Font.Bold = True Then
                CategoryList.AddItem Search.Value
            End If
        Next
    I tried it with find, findnext but still can't do it.
    Thank you in advance
    Last edited by jeffreybrown; 12-06-2012 at 11:06 PM.

Thread Information

Users Browsing this Thread

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

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