+ Reply to Thread
Results 1 to 9 of 9

Filter combobox from another combobox

  1. #1
    Registered User
    Join Date
    08-12-2013
    Location
    Cebu, Philippines
    MS-Off Ver
    Excel 2010
    Posts
    37

    Filter combobox from another combobox

    Hi Guys Good morning,

    Guys i need your help, im working on an excel vba(pls.see attached file) In the banquet details option, if you click banquet there's a form there, In the room arrangement & vip setup, if i want to click banquet, block, ushape,cocktails and theatre i want only in the arrangement combobox will filter regular and if i want to click classroom in type i want that the arrangement combobox will come out it will only select 4 option regular, perpendicular, fishbone and inverted. Thanks in advance. more power.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-12-2013
    Location
    Cebu, Philippines
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Filter combobox from another combobox

    Hi anyone knows on this?? im still new in vba excel. thanks.

  3. #3
    Registered User
    Join Date
    08-12-2013
    Location
    Cebu, Philippines
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Filter combobox from another combobox

    Hi Guys. badly need your help please.Thanks.

  4. #4
    Registered User
    Join Date
    08-12-2013
    Location
    Cebu, Philippines
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Filter combobox from another combobox

    help please. thanks

  5. #5
    Registered User
    Join Date
    08-12-2013
    Location
    Cebu, Philippines
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Filter combobox from another combobox

    thanks for your help in advance.

  6. #6
    Registered User
    Join Date
    08-12-2013
    Location
    Cebu, Philippines
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Filter combobox from another combobox

    uuuuuuuuuuppppp

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Filter combobox from another combobox

    I removed the rowsource reference for Arrangement (i.e.) Combobox4 and I made the drop down list of Combobox4 to get updated via coding.

    The combobox4 will get updated based on the selection change of Combobox3

    Here is the combobox3 change code.

    Please Login or Register  to view this content.
    Refer the attached file for details.

    Please do it for the rest of the combobox based on the above method/logic
    Attached Files Attached Files


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  8. #8
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Filter combobox from another combobox

    aimjhun -- you will not be gaining friends by bumping your thread every few hours or asking complete strangers to be your friend on this forum.

    As an alternative strategy consider

    - explaining the issue in the question
    - breaking a complex issue down into sub-questions

    If you need help with a problem, explain the problem in the text of your question. Don't expect people to download a workbook before they can learn what the question is about.

    And please, don't bump your thread every few hours. I think the forum rules say that you may only bump if your question has not received a reply in 24 hours. You may soon find that if you ignore the forum rules, there will be no forum here for you. You'll be shown the door.

    Your choice.

  9. #9
    Registered User
    Join Date
    08-12-2013
    Location
    Cebu, Philippines
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Filter combobox from another combobox

    As always thanks sixthsense your the best... Thanks guys for helping, and sorry for disturbing, im desperate :C. thanks again.

+ 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. Replies: 1
    Last Post: 11-07-2014, 01:21 PM
  2. [SOLVED] Filter Combobox base on selection from previous combobox
    By ciapul12 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-18-2013, 07:25 PM
  3. [SOLVED] Make combobox list options dependant on selection in another combobox within a userform
    By Vladimir_Dobvchenko in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-23-2013, 05:30 AM
  4. [SOLVED] Excel Userform: Populate other controls (i.e. textbox & combobox) based on combobox select
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 04:50 PM
  5. Combobox - Filter auto-filter worksheets (ActiveX)
    By Darms in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2011, 11:33 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