+ Reply to Thread
Results 1 to 7 of 7

VBA to trigger event change

  1. #1
    Registered User
    Join Date
    04-20-2011
    Location
    San Antonio, TX
    MS-Off Ver
    Excel 2010
    Posts
    31

    VBA to trigger event change

    Good Morning,

    I have a chart with 2 Y axis. I am attempting to write some code that will update both axis with the same max & min value that is triggered by the combobox selection. The code will update the axis but is not triggered by the combobox selection.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: VBA to trigger event change

    use the selectionchange option and filter the change (triggering ) to the combobox cell

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: VBA to trigger event change

    Have you assigned this sub to the combobox or is there other code?
    If posting code please use code tags, see here.

  4. #4
    Registered User
    Join Date
    04-20-2011
    Location
    San Antonio, TX
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: VBA to trigger event change

    I have not assigned the sub to the combobox. There is no other code.

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: VBA to trigger event change

    So how is the code meant to be triggered?

  6. #6
    Registered User
    Join Date
    04-20-2011
    Location
    San Antonio, TX
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: VBA to trigger event change

    I want it to be triggered by a selection from the combobox.

  7. #7
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: VBA to trigger event change

    Have you tried assigning it to the (Forms) combobox or calling it from the (ActiveX) combobox's Change event?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Trigger Change Event
    By alienware in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-27-2012, 07:25 AM
  2. Select Box Change Event Trigger
    By excelsupportforum in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-31-2012, 12:45 PM
  3. ComboBox within Frame - how to trigger a change event
    By Barbados in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2011, 03:19 AM
  4. Cell value change to trigger macro (worksheet change event?)
    By Neil Goldwasser in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2006, 10:00 AM
  5. Worksheet Change Event-change event to trigger
    By Steph in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-18-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1