Excel - Update calculations

December 2016



Issue


I have an Excel file in which I have several radio buttons. When I click on a radio button, it changes several cells and some containing listboxs. The problem is that when I change an item in my listboxs, values are not updated.

Solution


In VBA
  • ActiveWorkbook.RefreshAll

or
  • Worksheets("Feuil1").QueryTable.Refresh BackgroundQuery:=False


Thanks to anonymous1.0 for this tip.

Related :

This document entitled « Excel - Update calculations » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.