+ Reply to Thread
Results 1 to 2 of 2

Setting a value in a menu pop up control?

  1. #1
    Forum Contributor
    Join Date
    03-07-2013
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    274

    Setting a value in a menu pop up control?

    Hello,

    I have many pop up menus where each one can be set manually.

    The pop up menus have all the same 10 items in their list to choose from
    Which are 1 to 10.

    However sometimes it is required that all of them be set to the same
    value. It would be tedious to go through all the pop up menu controls
    One by one and set them all to for example 7. !!

    Is there a way where I could take a random cell (ex z1) on my sheet and if I want all the pop up menus to go to 7, I would manually put #7 in the
    Z1 cell and have all the pop up menu control show their 7th
    item in their list which is #7?

    Thank you

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Setting a value in a menu pop up control?

    iwhat platform is this for?
    excel? google sheets?

    do you mean a dropdown menu, a custom menu, or a popup dialog box?

    is there any chance you can upload a screenshot of one that is manually configured, so we can better understand what you are wanting to do?
    Last edited by janmorris; 10-29-2021 at 09:34 AM.

+ 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. Setting up Menu in Workbook
    By avonsprings in forum Excel General
    Replies: 4
    Last Post: 12-14-2012, 01:50 AM
  2. Setting up own menu on Excel ribbon
    By mahmudp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-18-2012, 12:27 PM
  3. Setting up frames in Excel using a pull down menu
    By CMatin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-16-2012, 01:04 PM
  4. Setting up a print menu option button
    By cycle_simon in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-16-2007, 04:32 PM
  5. Setting Control End Limit
    By Earl in forum Excel General
    Replies: 1
    Last Post: 04-20-2006, 03:35 PM
  6. [SOLVED] Setting an option control
    By Patrick Simonds in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-03-2006, 10:30 PM
  7. Replies: 1
    Last Post: 02-27-2006, 10:15 AM
  8. [SOLVED] setting ComboBox Control font
    By ts1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-22-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