Hi all - new to the message board, need a little help. I have some experience with VBA, but I am far from a master.
I essentially have a sheet where for each line (maybe 100 lines to a sheet) a reviewer selects a value from a very long drop down list to provide the status for the individual line. So, I want a drop down in every row in one column. I realize a validation list would be useful for this. However, the list of options is long and autocomplete would be ideal.
Having googled this for a little while, it seems that autocomplete and data validation lists do not go well together. I would create a combo box in each cell of the column, though I am not sure about how to go about that or if it would be finicky.
Any thoughts/help/suggestions are appreciated!
I essentially have a sheet where for each line (maybe 100 lines to a sheet) a reviewer selects a value from a very long drop down list to provide the status for the individual line. So, I want a drop down in every row in one column. I realize a validation list would be useful for this. However, the list of options is long and autocomplete would be ideal.
Having googled this for a little while, it seems that autocomplete and data validation lists do not go well together. I would create a combo box in each cell of the column, though I am not sure about how to go about that or if it would be finicky.
Any thoughts/help/suggestions are appreciated!
