+ Reply to Thread
Results 1 to 25 of 25

Custom UI Editor---->ComboBox Question

  1. #1
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Cool Custom UI Editor---->ComboBox Question

    Hi guru's,

    Following code works for Custom UI Editor, which makes a new Tab--->Group--->ComboBox
    Please Login or Register  to view this content.
    Everything is okey code above...


    My question is how can I change above code that, ComboBox get items from excel A column?

    Thanks in advance

    Note1: Following code works for normal excel vba.
    Please Login or Register  to view this content.
    But I need ComboBox worked with Custom UI Editor...

    Note2: You can use DropDown instead of ComboBox if you prefer.
    Last edited by HerryMarkowitz; 08-13-2014 at 08:37 PM.
    Sub DontForgetThese()
         If Your thread includes any code Then Please use code tags...
         If Your thread has been solved Then Please mark as solved...
         If Anybody has helped to you Then Please add reputation...
    End Sub

  2. #2
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Custom UI Editor---->ComboBox Question

    My question looks very diffucult to answer.

    I found two links regarding my question but they are very complicated !

    http://excelusergroup.org/blogs/nick...he-ribbon.aspx
    http://forums.techguy.org/business-a...d-combo-4.html

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Custom UI Editor---->ComboBox Question

    It's not difficult it's just different to what you are use to. Bit like using xml instead of VBA.

    As per the examples you need to use callbacks to pass information to the ribbon interface object.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Custom UI Editor---->ComboBox Question

    Hi Andy,
    I am aware that you are expert of this issue.
    http://www.andypope.info/vba/ribboneditor.htm
    So, I am looking forward of your asistance...


    In summary, my question is;
    "I want to use ComboBox Ribbon or DropDown Ribbon as autofilter!

    Note:
    My original excel sheet includes 1700 rows.
    I want filter one of 1700 rows from A column.
    Regards
    Last edited by HerryMarkowitz; 08-14-2014 at 08:57 AM.

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Custom UI Editor---->ComboBox Question

    I'm not sure what I can add to the threads you have already mentioned.

    You have 1700 unique items in column A?

    Why not use Autofilter if you are not comfortable with ribbon callbacks.

  6. #6
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Custom UI Editor---->ComboBox Question

    Good point !
    I am preparing this excel file for other users.
    And I want other users can not touch data.
    So, I want autofilter can be managed only from Ribbon...

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Custom UI Editor---->ComboBox Question

    In that case you will need to work through either one of those examples.

  8. #8
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Custom UI Editor---->ComboBox Question

    Hi Andy,
    I am decided to use checkbox ribbon.
    Enclosed file has 57 CheckBox designed by Custom UI Editor.
    I want to autofilter selected CheckBox value.

    For example if I checked XU100 CheckBox than XU100 values must autofilter from B column.

    Need you assistance.
    Attached Files Attached Files
    Last edited by HerryMarkowitz; 08-15-2014 at 07:51 PM.

  9. #9
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Custom UI Editor---->ComboBox Question

    My question is updated.
    My question exist in the #8 message.
    Please help.
    Regards.

  10. #10
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Custom UI Editor---->ComboBox Question

    code module

    Please Login or Register  to view this content.
    thisworkbook module
    Please Login or Register  to view this content.
    I added a button to clear filter on worksheet.
    It uses advance filter with criteria constructed in K1 onwards.
    Attached Files Attached Files

  11. #11
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Custom UI Editor---->ComboBox Question

    Hi Andy,
    Great job!
    Is it possible using normal filter instead of advanced filter ? (Because my excel sheet has full of data, and there is no free cell for advanced filter)

  12. #12
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Custom UI Editor---->ComboBox Question

    I can belive you are using all >16000 columns or >1 million rows such that you can't find space on the same sheet.

    Anyway try using a new sheet for the criteria. Add a worksheet called FilterInfo.
    Use this modified routine

    Please Login or Register  to view this content.

  13. #13
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Custom UI Editor---->ComboBox Question

    Hi Andy,
    My excel file very complicated already.
    So, I want to make my excel file simplier.
    This is why I need to use standart autofilter.

    I will try to change your code from advanced filter to normal filter.
    Just tell me that if changing your code from advanced filter to normal filter works or not ?
    Thanks for your support in advance.

  14. #14
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Custom UI Editor---->ComboBox Question

    as an option (maybe)
    Please Login or Register  to view this content.

  15. #15
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Custom UI Editor---->ComboBox Question

    Codes you sent are very diffucult for me to understand...
    Last edited by HerryMarkowitz; 08-17-2014 at 08:18 PM.

  16. #16
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Custom UI Editor---->ComboBox Question

    So, lets make this issue simplier.
    I worked on a new excel file which I attached has 5 CheckBoxes.
    When you click one of these CheckBoxes, you will see that autofilter done successfully.

    What I am gonna to do is "How I autofilter more than one selection ?

    For example, if I select X100S CheckBox and XU050 CheckBox, how both selection makes autofilter works ?
    Attached Files Attached Files

  17. #17
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Custom UI Editor---->ComboBox Question

    Quote Originally Posted by HerryMarkowitz View Post
    Codes you sent are very diffucult for me to understand...
    whether it works for you (I used the file from the post #10)
    Attached Files Attached Files

  18. #18
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Custom UI Editor---->ComboBox Question

    @nilem, your code appears to be an OR rather than AND.

    So XU100 and XTM25 checked results in 103 records rather than 22.

    @HerryMarkowitz, I don't think you can do it using auto filter. You can only apply 2 conditions.

  19. #19
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Custom UI Editor---->ComboBox Question

    Hi Andy,
    Yes, you're right. I'm not sure, but maybe this is what our Herry need?

  20. #20
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Custom UI Editor---->ComboBox Question

    Hi,
    Do you think I give up solving this issue ? Of course not

    Now,
    Open enclosed file ----> Run Macro1------>See that autofilter works more than one conditions.

    Next issue is "how I can manage this from CheckBox Ribbon ?
    Attached Files Attached Files

  21. #21
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Custom UI Editor---->ComboBox Question

    Need your support...

  22. #22
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Custom UI Editor---->ComboBox Question

    Before we waste our time writing any more code or providing solutions perhaps you should specify what you actually want.

    Your code does not autofilter more than 2 criteria. It does 1 criteria and outputs information to a sheet. Your code would work by the way if you used real data. instead of dummy data which currently produces no records when filtered.

  23. #23
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Custom UI Editor---->ComboBox Question

    Hi Andy,
    1- Open enclosed file existing #16 message.
    2- Click one of checkboxes,
    3- See that autofilter works successfully.

    My aim is to click more than one (two, three, four....) checkboxes, lets say XU100, XU050 and XU030, then autofilter works successfully for these three selection...
    Three click, one result...(one excel sheet)

    Best regards

  24. #24
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Custom UI Editor---->ComboBox Question

    That does not clarify.

    The code runs after each checkbox is clicked. So how would it know what sheet name to use if you have 3 items clicked?
    Also should the sheet contain records that contain (XU100 AND XU050 AND XU030) or is it records that contain (XU100 OR XU050 OR XU030)

    Autofilter will only work with a maxium of 2 choices. Try it manually and you will see the limitation.

  25. #25
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Istanbul / Turkey
    MS-Off Ver
    2013 - Win10 - 64bit
    Posts
    1,007

    Re: Custom UI Editor---->ComboBox Question

    I see.
    Lets stop here.
    Thanks for support.

+ 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] Custom UI Editor
    By britinva in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-04-2014, 09:10 AM
  2. How to create custom tabs using CUSTOM UI EDITOR in excel 2007
    By narendrabr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2014, 12:38 PM
  3. Zooming / Scaling Issue with Custom Cell Editor developed using WPF, ElementHost Control
    By BostonResident1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2012, 05:30 PM
  4. Problem using the new version of custom UI Editor
    By mridzuani in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2011, 05:03 AM
  5. [SOLVED] Editor question
    By Glen Mettler in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2005, 02:06 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