Hi VBA Access Guru's

I am unable to give dynamic listfillrange for a combobox. I have combobox in sheet 'abc' and data on sheet 'dropdown'. below is the code

cmbCities.ListFillRange = dropdownsheet.name!sdropdownrange

however i am getting the right sdropdownrange and valid sheet name.
but it all together doesn't work.

plz help ASAP.

Jani

ListFillRange is used in Excel. What you would want to use for Access is RowSource.

Try using cmbCities.RowSource = sSQL 'Where sSQL = attach string to your table / linked sheet (i.e. "Select * From TableName")

If this is for Excel then you may try using cmbCities.ListFillRange = Worksheets("Sheet Name").range(sdropdownrange)

If this isn't what you're looking for then further information and/or code sample and/or better description about what you're attempting would be required.

Hopefully this helped.
Al