How are you populating the comboboxes from the named range?
PS When posting code can you please use CODE tags?
Actually I don't think I've reference a named range I have just listed all cells in a column that aren't empty (code below):
![]()
Dim ws As Worksheet Dim LastRow As Long Dim aCell As Range Set ws = Worksheets("Outcomes") With ws LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row For Each aCell In .Range("A1:A" & LastRow) If aCell.Value <> "" Then Me.cbOutcome1.AddItem aCell.Value Me.cbOutcome2.AddItem aCell.Value Me.cbOutcome3.AddItem aCell.Value Me.cbOutcome4.AddItem aCell.Value Me.cbOutcome5.AddItem aCell.Value End If Next End With
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks