change cell link in combox box dynamically

K

Kate Yang

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
 
D

Dave Peterson

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
 
K

Kate Yang

Hi Dave,

Thank you very much for your help. I am very grateful.
You have saved my day.
 
Top