Skip to main content

CommandBars.OnUpdate event

Table of contents
  1. Syntax
  2. Remarks

Occurs when any change is made to a command bar.



expression A variable that represents a CommandBars object.


The OnUpdate event is recognized by the CommandBar object and all command bar controls. The event is triggered by any change to a command bar or command bar control or any change to the state of a command bar or command bar control. These changes can occur due to a text or cell selection, for example.

Because a large number of OnUpdate events can occur during normal usage, developers should exercise caution when using this event. It's strongly recommended that this event be used primarily for checking that a custom command bar has been added or removed by a COMAddIn.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>