To Update ComboBox

D

Daniel Utsch

How to do that a comboBox, update automatically? I have a comboBox, with the
ListFillRange be an interval of cells that name is "Fornecedor", in this
interval has the function (=OFFSET('Base Fornec'!$B$2;0;0;CONTA('Base
Fornec'!$B:$B)), but when these cells suffer modification or has add other
value in this interval, this comboBox doesn't update. The comboBox only
updates after me save the spreadsheet.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top