Hi Gary"s Student,

I tried to adjust this line of code to list the selections vertical instead
of horizontal and was unable to come up with the correct syntax. I
bonked...!

iCol = Cells(Target.Row, Columns.Count).End(xlToLeft).Column + 1

Regards,
Howard

"Willow1221" wrote in message
...
I know how to create a drop down list, however, I am trying to create a
tracking worksheet where users can select as many responses that apply.

Any ideas?
--
Willow1221