View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel Utsch[_2_] Daniel Utsch[_2_] is offline
external usenet poster
 
Posts: 22
Default To Update ComboBox

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