Maybe I need to clarify a little. The problem with making the cell wid
enough to accomodate the entire line of text for the class name is tha
it would be way too long.

Is it possible to create a userform box that will pop up for this cel
and after they make their selection it will write it to th
appropriate row?

Once it is selected I have the cell set to word wrap so it will no
take up as much room, it is just viewing the entire line of text tha
is the problem.

Does that make sense

--
Message posted from http://www.ExcelForum.com