Combobox List Fill Range
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.