+ Reply to Thread
Results 1 to 2 of 2

Count sheet with combo dropdown

  1. #1
    Registered User
    Join Date
    10-20-2018
    Location
    Aarhus, Denmark
    MS-Off Ver
    MS Office 365
    Posts
    1

    Count sheet with combo dropdown

    Hello,

    I work as an engineering intern, and one of my assignments is to record the number of fixtures on a pipe stretch. I thought I could save some time by making a dropdown-menu, able to select different kind of fixtures at a point and either assign a count to this (somehow from the dropdown menu). Im struggling with multiple selections. I can try to illustrate what i have in mind:

    Type of fixture at point:
    Sink---------------------------------> Hot, cold or both --------------------------> Count
    Shower
    Cleaning sink.
    etc.

    Is it possible to somehow get a table out of this, where I can extract the amount quicker than listing all the fixtures and write down the count for each? If you have other suggestions to counting these items I would gladly hear them.

    Thanks in advance!

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Count sheet with combo dropdown

    Hi and Welcome

    Interesting problem.

    I have developed a solution for you using four macros.

    Change A1 to add a fixture

    Click on Column B to Delete a Fixture.

    Two Macros are in a standard macro module.

    Select the developer tab
    Select view and then project explorer
    Select your project
    Select insert and then module
    Paste this code in the module that opens and close it.


    Please Login or Register  to view this content.


    The other two macros go in a sheet specific macro module.

    Right Click On Your Sheet Name At the Bottom Of Excel and Select View Code
    Paste this code in the module that opens and close it.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 10-20-2018 at 07:56 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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] Changing Worksheets Using Dropdown List (not combo box) that doesn't include sheet names
    By firebird_richie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-02-2017, 11:48 PM
  2. Combo box dropdown misbehaving
    By MattRNR in forum Excel General
    Replies: 17
    Last Post: 11-05-2015, 08:02 PM
  3. [SOLVED] Conditional Dropdown Combo Box
    By KMCurtis in forum Excel General
    Replies: 5
    Last Post: 08-12-2014, 12:42 PM
  4. Dropdown combo in excel
    By svantaylor in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 03-03-2014, 11:55 AM
  5. Replies: 0
    Last Post: 08-22-2012, 03:52 PM
  6. [SOLVED] Combo Box List Dropdown
    By HornJM in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2006, 05:15 PM
  7. Combo dropdown open
    By mino in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-08-2005, 11:05 AM

Tags for this Thread

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