+ Reply to Thread
Results 1 to 2 of 2

Menu with options that will be added to the next line

  1. #1
    Registered User
    Join Date
    03-25-2014
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Menu with options that will be added to the next line

    Hi All,

    I am new to VBA so needing some help.

    What I am trying to do is have a menu item with a button next to it.
    When the button is clicked there will be a pop up that has options in a drop down menu to select (I was thinking a user form would be easiest for this)
    Then when the user form is accepted it will add the selection to the line underneath the heading and then if another one is selected continue on this.

    The problem I have is that initially there are no gaps between the menu items so a new row would need to be created before the selection could be pasted.

    Hopefully this makes sense.

    Jake

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Menu with options that will be added to the next line

    Please attach a workbook showing how it is structured, and what your required outcome looks like.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. Marker and Line Color Options in Excel Line Graph
    By Slmoore in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-21-2013, 12:55 PM
  2. Drop down menu, need a choice added
    By shanshine in forum Excel General
    Replies: 4
    Last Post: 09-28-2011, 03:37 PM
  3. Need an option added into a drop down menu
    By Ray_n_yellow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-12-2009, 11:55 PM
  4. Subscript font (for added Menu)
    By arora in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-06-2008, 08:26 AM
  5. [SOLVED] Menu items added with menu item editor in older versions
    By Michael Hoffmann in forum Excel General
    Replies: 2
    Last Post: 01-07-2005, 10:06 AM

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