Results 1 to 5 of 5

Combo Box (Form Control) With Macro On A Graph Sheet

Threaded View

splendidus Combo Box (Form Control) With... 05-30-2012, 11:07 AM
Andy Pope Re: Combo Box (Form Control)... 05-31-2012, 04:35 AM
splendidus Re: Combo Box (Form Control)... 05-31-2012, 09:07 AM
Andy Pope Re: Combo Box (Form Control)... 05-31-2012, 09:25 AM
splendidus Re: Combo Box (Form Control)... 06-05-2012, 03:57 AM
  1. #1
    Registered User
    Join Date
    05-09-2012
    Location
    USA
    MS-Off Ver
    2019 16.0.13205.200000 64-bit
    Posts
    61

    Question Combo Box (Form Control) With Macro On A Graph Sheet

    Guys, I have another interesting challenge. I have a sheet, which is a graph (e.g. when you select a graph, right click > MOVE TO NEW SHEET). On that graph-sheet I need to add a "Combo Box (Form Control)" and attach a separate macro to each of the list points in the box. Meaning, when I choose entry one one a list, macro 1 is run, when I choose entry 2 on a list, macro 2 is run, etc.
    I dug up that this IS possible using an ActiveX object ["Combo Box (ActiveX Control)"]. However, since the whole graph is a separate sheet, I can't put (area s grayed out) a "Combo Box (ActiveX Control)" object onto it and hence I can't use it.

    So my questions are:
    - Is it possible to somehow put Combo Box (ActiveX Control) onto a such a graph-sheet?
    - Is it possible to realise what I need via Combo Box (Form Control) object somehow? (how to attach a separate macro to each list entry)

    Again, the punchline of what I need to do is: with selection of each entry from a list of my Combo Box (Form Control)/Combo Box (ActiveX Control) a separate macro should run, e.g. with 10 points in the list 10 macro will be assigned, with each macro running when a corresponding list point is selected.



    Any help would be much appreciated!
    Last edited by splendidus; 05-30-2012 at 12:15 PM.
    Office 2019 16.0.13205.200000 64-bit

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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