Results 1 to 16 of 16

Add a line based on values VBA

Threaded View

  1. #1
    Registered User
    Join Date
    04-19-2010
    Location
    belgium
    MS-Off Ver
    Office 365
    Posts
    53

    Add a line based on values VBA

    Good day everyone,
    I need help.. :-)
    I have an excel form where requestor needs to select some values in a drop down list. If the value choosen is "Extend" or "Modify" a new line is created just below so requestor can add the product number that needs to be modified/extended.

    Two problems i cannot solve :
    1) when the line is added, the drop down list from above (the one requestor used to make his choice) is also created where i shuold have an empty cell where user will mention his product number.
    2) further down in the same column, i have another cell where requestor needs to choose in the drop down list (F or E or X), based on the answer, a new line should be created below (without the drop down list from above of course)

    this file is created as a table, but can be removed this is not an issue for me.

    Attached you will find the file with explanations

    Thank you for the help
    Guismo30
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 05-29-2021, 03:04 AM
  2. Color series on a line chart based on cell values.
    By zealot in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 11-12-2020, 11:35 AM
  3. Blank/NA values to be shown as dotted line rather than straight line in Charts
    By palaniappan0212 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-29-2016, 01:01 AM
  4. Line Graph question - vetical line values at one fixed date
    By bohn in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-12-2015, 02:22 PM
  5. Create line item rows based on values between two dates
    By eeidmna in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2014, 01:55 PM
  6. Combining multiple line items into one line item based on column.
    By mguz018 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-20-2012, 07:22 PM
  7. Report a list line by line based on name criteria
    By cptnmorgan9999 in forum Excel General
    Replies: 9
    Last Post: 06-24-2008, 11:35 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