Combo box Dynamic Input Range

[Leeinsa]

A more difficult one this time.

Is there a way of setting the input range on a combo box to a vale set in a cell?

ie, if my current input range is A2:A40 and i then users add another 20 records to that column, i need the combo box input range to change to A2:A60, so I can leave the sheet unmonitored for the users to add lines and not have to manually change the input range of the combo box.

Many thanks,

Lee.

 

[Leeinsa]

Sahak,

Just to let you know i finally got round to trying your code and managed to tweak it to work perfectly in my sheets.

Many many thanks,


Lee.

 

[Sahak]

You are welcome