+ Reply to Thread
Results 1 to 2 of 2

A script to insert a row below based upon the value of a drop down box selection

  1. #1
    Registered User
    Join Date
    01-29-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    4

    A script to insert a row below based upon the value of a drop down box selection

    So, I tried to put all the info into the title but here's the expanded version.
    I'm working on a template to put together to send to some clients of mine and there's one worksheet where I'd like to insert a row (from another worksheet or cell) contingent upon whether or not a specific drop down menu was selected.

    Is this even possible?

    Let me give a little more information.
    I'm trying to have a client fill out survey questions. However, sometimes the category changes or the demographic data changes, when one of those drop down boxes is selected then I would like to add a row (or even un-hide one below it)
    Last edited by dextryn; 02-13-2013 at 01:48 PM.

  2. #2
    Registered User
    Join Date
    02-07-2013
    Location
    NJ USA
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: A script to insert a row below based upon the value of a drop down box selection

    dextryn,

    you need to provide more information on where your difficulty is.

    If the clients will return the survey back to you, then you can add code to the survey in the event for the drop-down that will set a value in a cell in a hidden sheet. This way you will know what drop downs were used and you would be able to insert rows as needed when the survey is returned

    If you want this to happen at the time when the client selects the drop down then once again you can use an event to insert a row from a hidden sheet or un-hide a hidden row

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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