+ Reply to Thread
Results 1 to 3 of 3

Control shapes via dropdown menu

  1. #1
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Control shapes via dropdown menu

    Hi,

    I have a word document where I have placed a map of Canada. When the user opens the file then they should only see the map + 2 activex combo boxes. Once they have picked from the two lists then specific circles should appear and they should be sized according to a specific data I have.

    What I need help with is how to control the shapes from the dropdown menus and how to control the shapes (appear/ disappear and resize).

    Thanks.

    abousetta
    Attached Files Attached Files
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: Control shapes via dropdown menu

    OK, so your document has some ActiveX controls (is there a good reason for not using content controls?), but there's no indication of how the code behind them (unusable is a docx file, anyway) is related to how the "circles should appear and they should be sized". In any event, to do that, you'd probably want to name the shapes for referencing purposes, using code like:
    ActiveDocument.Shapes(1).Name = "Canada"
    Having done that, you can refer to them and adjust their size & position quite easily, using code like:
    Please Login or Register  to view this content.
    'Oval 8' is one of the existing names.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Control shapes via dropdown menu

    Thanks Paul. I understand the concept now.

+ 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] How a drop down menu's list can change depending on another dropdown menu.
    By marc1980 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-21-2014, 04:58 PM
  2. [SOLVED] Toggle visibility of shapes via dropdown list between workbooks
    By GuyL23 in forum Excel General
    Replies: 1
    Last Post: 03-07-2014, 07:11 AM
  3. [SOLVED] Excel 2007 : new drop down menu based on dropdown menu in previous cell
    By martinpols in forum Excel General
    Replies: 3
    Last Post: 04-30-2012, 02:33 AM
  4. Create Dropdown menu without using the Validation on the Data Menu
    By lostinformulas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-13-2006, 03:47 PM
  5. Programatically control a shapes TextBox
    By Francis Brown in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2005, 02: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