You'd either have to do it manually or have a macro do the work (maybe the
insert, too??).
But it might be easier using Data|Validation. It kind of works like that
combobox and it's lots easier to implement.
Debra Dalgleish has tons of tips and hints at:
http://www.contextures.com/xlDataVal01.html
Kate Yang wrote:
I am using combox box with cell link as A1. I then make a copy of the row.
The new combox box's cell link still is A1. How do I change it to where the
new row is?
thank
--
Dave Peterson