Hi
I have a combo box ( inserted from Developer and User form control, not active x) which is filled dependent on list of depts in column T. It's a dependent combo box and populated based on department chosen and can have 4 records or 50
The issue is that the combo box can show a lot of blanks and user has to scroll up to the top of combo box to get to first record again ( which many dont know they can do and just assume nothing in combo box)
I tried this offset as I though this would resolve but this still highlights blank rows
=OFFSET(Look!$T$1,1,0,COUNTA(Look!$T:$T)-1,1)
Not really sure what I'm doing wrong and I'm just trying to populate combo box with only records shown in column T and not have any blanks in the combo box.
How can I have a user choose from drop down combo and have reset so when another unit chosen the dept combo box is reset to top record?
hope this makes sense and any help greatly appreciated
regards
I have a combo box ( inserted from Developer and User form control, not active x) which is filled dependent on list of depts in column T. It's a dependent combo box and populated based on department chosen and can have 4 records or 50
The issue is that the combo box can show a lot of blanks and user has to scroll up to the top of combo box to get to first record again ( which many dont know they can do and just assume nothing in combo box)
I tried this offset as I though this would resolve but this still highlights blank rows
=OFFSET(Look!$T$1,1,0,COUNTA(Look!$T:$T)-1,1)
Not really sure what I'm doing wrong and I'm just trying to populate combo box with only records shown in column T and not have any blanks in the combo box.
How can I have a user choose from drop down combo and have reset so when another unit chosen the dept combo box is reset to top record?
hope this makes sense and any help greatly appreciated
regards