The combobox from the control toolbox toolbar allows editing and is available
for both userforms and worksheets.

--
Regards,
Tom Ogilvy


"blackbox via OfficeKB.com" wrote:

is it possible to use this out side of a form? (put it in a worksheet)

if it isn't I can move everything else on to the form but I just got the
worksheet setup and distributed the way I want it.

Also, is it possible to have more than one list for the drop-down + edit line
that would change based on a set of criteria like another combo box or list
box?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200706/1