Thread: ListFill Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
N.F[_2_] N.F[_2_] is offline
external usenet poster
 
Posts: 65
Default ListFill Range

Hello I have a comboBox with two items listed through the listfill range. It
seems that whenever I want to add another item under the combobox I cannot
simply change the listfill range and have the combobox update to the new
items. I must save it then open it up again, hit " enable macros" then and
only then will the new item under the combobox appear. WHY?????????

Is there a macro that allows to update the excel workbook (specifically the
comboBOx)???