Hi, I wonder whether someone may be able to help me please.
I'm using this example Excel vba: Populate a combo box (form control) | Get Digital Help - Microsoft Excel resource to create a combo box which contains unique values from a given spreadsheet list.
If I use the default layout provide in the example, I can re-create the the desired outcome. However if I cut and paste th elist to a different location i.e F2 instead of A2, I loose the list from the combo box.
I've changed the code from
to
to account for this, but I still can't get this to work.
I just wondered whether somoene may be able to look at this please and let me know where I'm going wrong.
Many thanks and kind regards
Chris
I'm using this example Excel vba: Populate a combo box (form control) | Get Digital Help - Microsoft Excel resource to create a combo box which contains unique values from a given spreadsheet list.
If I use the default layout provide in the example, I can re-create the the desired outcome. However if I cut and paste th elist to a different location i.e F2 instead of A2, I loose the list from the combo box.
I've changed the code from
Code:
With Worksheets("Sheet1")
Lrow = .Range("A" & Rows.Count).End(xlUp).Row
temp = .Range("A2:A" & Lrow).Value
End With
to
Code:
With Worksheets("Sheet1")
Lrow = .Range("F" & Rows.Count).End(xlUp).Row
temp = .Range("F2:F" & Lrow).Value
End With
to account for this, but I still can't get this to work.
I just wondered whether somoene may be able to look at this please and let me know where I'm going wrong.
Many thanks and kind regards
Chris