Combobox ListFillRange

[jammer6_9]

Comboboxes were created in the Worksheets. I am trying to use a ListFillRange IN Combobox2 when Combox1.value is true but gives me "Unspecified Error"

[vba]
Private Sub cmbRest1_Change()
If cmbRest1.Value = "BK-KSA" Then 'combox1
With cmbBrand1 'combobox2
.Clear
.ListFillRange = Sheets("SOURCE").Range("D423").Value 'or can I use .AddItem?


End With
End If


End Sub

[/vba]

[Bob Phillips]

[vba]

Private Sub cmbRest1_Change()
If cmbRest1.Value = "BK-KSA" Then 'combox1
With cmbBrand1 'combobox2
.Clear
.ListFillRange = Sheets("SOURCE").Range("D423").Address
End With
End If

End Sub
[/vba]


__________________________________________
UK Cambridge XL Users Conference 29-30 Nov
http://www.exceluserconference.com/UKEUC.html

[jammer6_9]

Same error still pointing to .clear but when i remove this, there was no error bu tno value comes out in the combobox.

[Bob Phillips]

What sort of combo is it, forms or control toolbox?


__________________________________________
UK Cambridge XL Users Conference 29-30 Nov
http://www.exceluserconference.com/UKEUC.html

[jammer6_9]

Control ToolBox...

[Bob Phillips]

Of course, you can't use/don't need Clear in a bound combobox.

Just ditch that line.

[jammer6_9]

As i ditch ".clear" line, no error pops in but no value showing in the combobox.

[Bob Phillips]

Is you sheet range full of data?