Howdy,
I'm having difficulty doing something that seems like it should be very simple.
I have a combo box on the first sheet of an Excel file. I need to fill the combo box with data in a range on the second sheet. The range needs to accommodate a variable for the row because it could grow as the user continues with other parts of the macro.
I've looked and searched for examples but can't seem to find one that I can make work. I've been trying to use .listFillRange method because it is supposed to show the list instead of adding to the bottom of the list like .AddItem seems to do.
Can someone show me how to do this?
Tobin Sparks
I'm having difficulty doing something that seems like it should be very simple.
Code:
Private Sub cbx_RevLookUp_DropButtonClick()
Dim ListRng As String
Application.ScreenUpdating = False
ListRng = Sheet2.Range("Y102:Y108")
Sheet1.cbx_RevLookUp.ListFillRange = ListRng
End Sub
I have a combo box on the first sheet of an Excel file. I need to fill the combo box with data in a range on the second sheet. The range needs to accommodate a variable for the row because it could grow as the user continues with other parts of the macro.
I've looked and searched for examples but can't seem to find one that I can make work. I've been trying to use .listFillRange method because it is supposed to show the list instead of adding to the bottom of the list like .AddItem seems to do.
Can someone show me how to do this?
Tobin Sparks