Auto populate Combobox from range

Question

I am using Excel 2013 and I have written the below code to auto populate a combobox from a range for one of my userforms. I have the combobox named "Times"

Sometimes this populates the list and other times it gives a blank list even though the range did not change.

Any idea how to stop this and just have it work everytime?

Private Sub UserForm_Initialize()
    Sheets("Backend").Visible = xlSheetVisible
    Times.RowSource = Sheets("Backend").Range("E1:E96").Address
    Sheets("Backend").Visible = xlVeryHidden
End Sub

score 0 · Accepted Answer · edited May 23 '17 at 11:51

0

I have found a different way to do this now that works. Thanks to this post.

Populate list box with a named range

edited May 23 '17 at 11:51

Community

1
1

answered Jul 14 '16 at 16:12

Chad Portman

1,134
4
12
38

Auto populate Combobox from range

1 Answers1