+ Reply to Thread
Results 1 to 3 of 3

Need help making a pull down menu the changes the output of data between SF, LF and Each

  1. #1
    Registered User
    Join Date
    03-25-2014
    Location
    Hamilton, ON, Canada
    MS-Off Ver
    Excel 2013
    Posts
    2

    Need help making a pull down menu the changes the output of data between SF, LF and Each

    So what I need to do is have a pulldown box that contains SF, LF and Each. I want it so when you select square feet there will be two boxes length and width that can be typed in and the square footage calculated. When you select linear feet I want the width box to no longer be able to be typed in and the linear footage calculated. Then when Each is selected I want the length and width boxes both disabled and the total calculation will be just based on quantity.I am using Excel 2013 and any help would be greatly appreciated.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: Need help making a pull down menu the changes the output of data between SF, LF and Ea

    Hi and welcome to the forum

    You would probably do this with Data Validation - custom, but to be more specific, you will need to upload a sample workbook
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    03-25-2014
    Location
    Hamilton, ON, Canada
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Need help making a pull down menu the changes the output of data between SF, LF and Ea

    I have attached a sample workbook. XXXXX-Dwg parts list- Template (In Progress)v5.xls
    Last edited by a_dundas2; 03-25-2014 at 02:52 PM.

+ 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] Font Size in Data Validation Pull Down Menu
    By LonnieLSmith in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-16-2013, 02:09 AM
  2. Variable Data from a Pull Down Menu
    By ameretsu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-15-2008, 04:51 AM
  3. [SOLVED] how do I enter more data to an already made pull down menu
    By Queenyvix in forum Excel General
    Replies: 1
    Last Post: 02-16-2006, 04:10 PM
  4. Data Validation or Pull Down Menu
    By r wilcox in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2005, 07:06 PM
  5. [SOLVED] External Data to be used as in a pull down menu in Excel2003
    By keith perdue via OfficeKB.com in forum Excel General
    Replies: 1
    Last Post: 01-26-2005, 11: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