Hi all - have recently built a userform containing combo boxes that i have turned into a drop down list.
the way it works is that on my sheet named 'lists' i have a named range. Then in the properties of the combo box i have typed the name of the named range in field RowSource.
the problem is that sometimes it will show me all of the contents of the named range and sometimes it wont.
I have extended the ListRow field to 30 and it still won't consistently work.
is there something I am missing or a better way to get my drop down list on the userform?
TIA
the way it works is that on my sheet named 'lists' i have a named range. Then in the properties of the combo box i have typed the name of the named range in field RowSource.
the problem is that sometimes it will show me all of the contents of the named range and sometimes it wont.
I have extended the ListRow field to 30 and it still won't consistently work.
is there something I am missing or a better way to get my drop down list on the userform?
TIA