dcsimg
Results 1 to 24 of 24
  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 2018
    Posts
    13

    CheckBoxCombo 1.3 (A professional, effective and ready-to-use Multi-select ComboBox)

    What is CheckBoxCombo?

    CheckBoxCombo is a general-purpose Multi-select ComboBox User Control designed for Visual Basic. It differs from the conventional ComboBox behavior by allowing user to select one or more items from its drop-down list. CheckBoxCombo greately integrates the existing power of standard VB controls (ComboBox and ListBox) to provide its powerful features and can be easily integrated into any sort of Windows GUI project in VB. Sure, it's a must to have companion in your standard VB Toolbox.

    Why is CheckBoxCombo?

    The conventional ComboBox control in VB allows you to select only one item at a time from its drop-down list. It cannot be used in situations where you need to select more than one item at a time. For this particular purpose you should use a multi-choice enabled ListBox, which is all right, if you have enough space on your interface/form. But what if you have a very limited space to place the ListBox with dozens of items; may be closer to the bottom of your interface? CheckBoxCombo is a great replacement in such situations where you need to save the space on your UI (User Interface), with its great dynamic features.

    CheckBoxCombo is also elegant in providing multiple inputs to SQL queries in database programming.

    Further, CheckBoxCombo allows you to set any of its properties even at run-time, which is not even allowed by the traditional ComboBox control. One such property is [sorted], which you can dynamically set the sorting at run-time. This gives you a great flexibility in using the user control simply by overriding the design-time settings as you wish. CheckBoxCombo also exposes some methods to support less coding when working with it.

    Its [OnListSearch] property helps user to search and select any item in the list easily.

    The user control greatly supports for modern visual styles since it integrates the existing VB controls which support visual styles.

    The ActiveX version of CheckBoxCombo is fully compatible even with VBA, if you need to use CheckBoxCombo with Microsoft Office (32-bit) as well.

    With CheckBoxCombo's professional features and familiarity in use due to nearly familiar syntax it provides, you will more feel it like a must to have control in your standard VB Toolbox.

    Outstanding features of CheckBoxCombo:

    • Professional, effective and ready-to-use design for any sort of Windows GUI project in VB
    • No dependent modules, extremely easy to integrate as a single module
    • Extremely easy to use
    • Ability to setup all supported properties even at run-time
    • Very smooth and faster operation, even with thousands of items
    • Dynamic sorting on ascending or descending, supporting thousands of items
    • Supports for different longest-text-display modes
    • Search-and-select feature for items
    • Exposes methods to support less coding
    • Highly flexible and configurable
    • Powerful and reliable on all supported operations
    • User friendly and familiar syntax
    • Supports for all flavors of Windows from Windows XP with visual styles
    • Full ActiveX compatibility with VBA (Microsoft Office 32-bit)
    • And more...

    Note: Please go through the User Documentation and study the Demo Application attached herewith, so that you may get a clear idea about CheckBoxCombo.

    Comments, suggestions are greatly welcome...

    Version History:
    Code:
      
     Revision update 1.3.2 (18-07-2018)
     ----------------------------------
     • Made internal improvements in hooking machanism
     • Bugfixes in ActiveX
     
     CheckBoxCombo 1.3 (15-07-2018)
     ------------------------------
     • Made changes to ActiveX version to be fully compatible with VBA. 
       Now it’s possible to use CheckBoxCombo even in UserForms, 
       Spreadsheets, Documents, etc. in Microsoft Office 32-bit editions
     • Optimized hooking mechanism
     • Fixed issues with MDI
     • Fixed issues related to Display Monitor
     • Fixed issues with mouse-wheel and scrollbars
     • Made minor changes to documentation 
    
     CheckBoxCombo 1.2 (05-07-2018)
     ------------------------------
     • Included FillList method. Now the list can be filled by
       a String/Variant type array 
     • Fixed the scrollbar issue
     • Enhanced the mouse-click support for selecting/unselecting
       items in the list. Now mouse-click supports anywhere on the 
       list item for quick selections
     • Fixed several minor bugs and general optimizations were done 
     • Updated User Documentation
      
     CheckBoxCombo 1.1 (30-06-2018)
     ------------------------------
     • Made syntax changes of AddItem, RemoveItem and FindItem methods
     • Introduced DelimiterConact Property 
     • Introduced CBCUPdate Property
     • Introduced CBCUpdateCompleted event
     • Revised <Change> event in v1.0 to <ItemCheck>
     • Fixed several bugs and some optimizations were done
     • Updated User Documentation 
    
     CheckBoxCombo 1.0 (26-06-2018)
     ------------------------------
     • The initial version of CheckBoxCombo
    Attached Images Attached Images     
    Attached Files Attached Files
    Last edited by PGBSoft; Jul 17th, 2018 at 11:31 PM. Reason: Version changed

  2. #2
    PowerPoster Elroy's Avatar
    Join Date
    Jun 2014
    Location
    Near Nashville TN
    Posts
    4,386

    Re: CheckBoxCombo 1.1 (A professional, effective and ready-to-use Multi-select ComboB

    Very nice implementation.

    And welcome to VBForums.
    Elroy
    Any software I post in these forums written by me is provided “AS IS” without warranty of any kind, expressed or implied, and permission is hereby granted, free of charge and without restriction, to any person obtaining a copy. Please understand that I’ve been programming since the mid-1970s and still have some of that code. My contemporary VB6 project is approaching 1,000 modules. In addition, I have a “VB6 random code folder” that is overflowing. I’ve been at this long enough to truly not know with absolute certainty from whence every single line of my code has come, with much of it coming from programmers under my employ who signed intellectual property transfers. I have not deliberately attempted to remove any licenses and/or attributions from any software. If someone finds that I have inadvertently done so, I sincerely apologize, and, upon notice and reasonable proof, will re-attach those licenses and/or attributions. To all, peace and happiness.

  3. #3

    Thread Starter
    New Member
    Join Date
    Jun 2018
    Posts
    13

    Re: CheckBoxCombo 1.1 (A professional, effective and ready-to-use Multi-select ComboB

    Thank you for the nice comment.

  4. #4
    Frenzied Member gibra's Avatar
    Join Date
    Oct 2009
    Location
    ITALY
    Posts
    1,543

    Re: CheckBoxCombo 1.1 (A professional, effective and ready-to-use Multi-select ComboB

    I found a bug.

    If I select the Select all items checkbox, will select all same item. Example:

    SelectedText return:
    Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka

    Select Count return: 20

    Select ItemData return :
    1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1

    Selected Item Indexes/numbers return:
    0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

  5. #5

    Thread Starter
    New Member
    Join Date
    Jun 2018
    Posts
    13

    Re: CheckBoxCombo 1.1 (A professional, effective and ready-to-use Multi-select ComboB

    Quote Originally Posted by gibra View Post
    I found a bug.

    If I select the Select all items checkbox, will select all same item. Example:

    SelectedText return:
    Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka,Sri Lanka

    Select Count return: 20

    Select ItemData return :
    1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1

    Selected Item Indexes/numbers return:
    0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
    gibra,
    I tried for this bug on WinXP, Win7 32/64-bit, and Win10 64-bit, but, unfortunately, I couldn't reproduce it. See the attached screenshot on Win10.

    Name:  ui-test.png
Views: 310
Size:  25.4 KB

  6. #6
    Hyperactive Member
    Join Date
    Jul 2007
    Location
    Essex, UK.
    Posts
    402

    Re: CheckBoxCombo 1.1 (A professional, effective and ready-to-use Multi-select ComboB

    I too have the same bug as Gibra Win 10 1803 17134.137. Just clicked on 'Select All Items' in the IDE with the following result!
    Attached Images Attached Images  

  7. #7
    Hyperactive Member
    Join Date
    Jul 2007
    Location
    Essex, UK.
    Posts
    402

    Re: CheckBoxCombo 1.1 (A professional, effective and ready-to-use Multi-select ComboB

    OK....It works ok as an exe. However you need to have it work during testing/design!!!

  8. #8

    Thread Starter
    New Member
    Join Date
    Jun 2018
    Posts
    13

    Re: CheckBoxCombo 1.1 (A professional, effective and ready-to-use Multi-select ComboB

    Steve,

    I tried to reproduce the issue in VB IDE (SP6) on Win 10 Pro 64-bit, but no issue found. Anyway, I will further check and re-upload the stuff.

    Thanks.
    Last edited by PGBSoft; Jun 30th, 2018 at 09:21 PM.

  9. #9
    PowerPoster Elroy's Avatar
    Join Date
    Jun 2014
    Location
    Near Nashville TN
    Posts
    4,386

    Re: CheckBoxCombo 1.1 (A professional, effective and ready-to-use Multi-select ComboB

    Quote Originally Posted by PGBSoft View Post
    If you are referring to “On Error Resume Next” statements in property settings, yes, most of them should not be. I simply put them at one stage of the development for a particular testing; hence they need to be cleared. Anyway, I will update the code. Thanks for pointing out it, which I had missed.

    For your question about Text property setting, the property is not purposely allowed to set, since it is considered to be a read-only property. The reason is simply integrity purpose, because, the user is only allowed to select items from the list, where the selection is updated as the Text. If it is allowed to set this Text externally, it is going to be a problem. Simply, imagine a Dropdown list style of a regular ComboBox; its Text property setting is read-only when the Text to be set is not in the list. However, you can still set the Text here via the DefaultText property, but that is for a different purpose.
    Hi PGBSoft,

    I thought I'd just jump over here since newbie2 has his thread marked as resolved.

    Regarding the "On Error Resume Next", I don't mind them as long as I know what they're for. However, I've also gotten into the habit of "closing" them with "On Error Goto 0" in the same procedure. If you don't do that, you might leave an error number in the Error object. That was illustrated to me by Bonnie West quite some time ago.

    Also, I guess I need to do more testing. However, I use a ComboBox as a "Dropdown List" quite often. But, when storing and fetching data from a database, I often use the .Text property to put the last value back into the ComboBox.

    In my simpler ComboCheck control, I just do it all in a very similar way. I probably need to "play" more, as I'm sure you have a way to indicate the previously selected value(s) in your control, just not through the .Text property.

    Let me outline a bit more of an example. My software is all medical (basically handicapped children). Let's say we're tracking what braces they wear. Some options are AFO, SMO, UCBL, etc. This is one place I use my multi-select combo, in that they may have more than one that they wear for different occasions. This is stored as a semi-colon separated string in the database. When the therapist re-examines the patient's encounter, the list (somehow delimited) should re-appear in the ComboBox.

    Take Care,
    Elroy
    Any software I post in these forums written by me is provided “AS IS” without warranty of any kind, expressed or implied, and permission is hereby granted, free of charge and without restriction, to any person obtaining a copy. Please understand that I’ve been programming since the mid-1970s and still have some of that code. My contemporary VB6 project is approaching 1,000 modules. In addition, I have a “VB6 random code folder” that is overflowing. I’ve been at this long enough to truly not know with absolute certainty from whence every single line of my code has come, with much of it coming from programmers under my employ who signed intellectual property transfers. I have not deliberately attempted to remove any licenses and/or attributions from any software. If someone finds that I have inadvertently done so, I sincerely apologize, and, upon notice and reasonable proof, will re-attach those licenses and/or attributions. To all, peace and happiness.

  10. #10

    Thread Starter
    New Member
    Join Date
    Jun 2018
    Posts
    13

    Re: CheckBoxCombo 1.1 (A professional, effective and ready-to-use Multi-select ComboB

    Quote Originally Posted by Elroy View Post
    In my simpler ComboCheck control, I just do it all in a very similar way. I probably need to "play" more, as I'm sure you have a way to indicate the previously selected value(s) in your control, just not through the .Text property.

    Let me outline a bit more of an example. My software is all medical (basically handicapped children). Let's say we're tracking what braces they wear. Some options are AFO, SMO, UCBL, etc. This is one place I use my multi-select combo, in that they may have more than one that they wear for different occasions. This is stored as a semi-colon separated string in the database. When the therapist re-examines the patient's encounter, the list (somehow delimited) should re-appear in the ComboBox.
    Elroy
    Yes, that is pretty easy with CheckBoxCombo. Just get the selected indexes or items with .SelIndex() or .SelItem() methods and save it in the database. When you restore them just call .SelectList(Your saved values in db). Please refer the Documentation. It is always better to save the indexes in the database if you have a fixed list. Please see the below code blocks too.

    For getting selected Indexes/Items in the list with CheckBoxCombo

    Code:
    'Read whatever value you need, Indexes/Items
    
    Dim varIndexes As String: varIndexes = CheckBoxCombo.SelIndex 'get all the selected indexes
    Dim varItems as String: varItems = CheckBoxCombo.SelItem 'get all the selected items
    
    'Now store/save whatever value you need, Indexes/Items, may be in your database
    For restoring Indexes/Items in the list with CheckBoxCombo

    Code:
    'Read whatever stored/saved value you need, Indexes/Items, may be from your database
    
    Dim varRestoreIndexes As String: varRestoreIndexes = 'read the previously stored index values
    Dim varRestoreItems as String: varRestoreItems = 'read the previously stored items
    
    'Restore whatever value you need, Indexes/Items
    
    CheckBoxCombo.SelectList(varRestoreIndexes) 'restore/select the indexes in the list
    CheckBoxCombo.SelectList(varRestoreItems, Item) 'restore/select the items in the list
    Hope this is easy as 1 2 3 and saves pretty much of your code, isn't it?
    Please read the documentation for more information.
    Last edited by PGBSoft; Jul 1st, 2018 at 09:50 PM.

  11. #11

    Thread Starter
    New Member
    Join Date
    Jun 2018
    Posts
    13

    Re: CheckBoxCombo 1.1 (A professional, effective and ready-to-use Multi-select ComboB

    Steve,

    I have made some fixes, can you check it now...
    Thanks

  12. #12
    Hyperactive Member
    Join Date
    Jul 2007
    Location
    Essex, UK.
    Posts
    402

    Re: CheckBoxCombo 1.1 (A professional, effective and ready-to-use Multi-select ComboB

    Just tested in IDE - All ok now thanks.

  13. #13
    Frenzied Member gibra's Avatar
    Join Date
    Oct 2009
    Location
    ITALY
    Posts
    1,543

    Re: CheckBoxCombo 1.1 (A professional, effective and ready-to-use Multi-select ComboB

    Quote Originally Posted by Steve Grant View Post
    Just tested in IDE - All ok now thanks.
    I confirm, too.

    Good work PGBSoft!!!
    This is a very usefull control.
    A control that was missing, and now there is!

  14. #14
    Frenzied Member
    Join Date
    Jan 2010
    Posts
    1,102

    Re: CheckBoxCombo 1.1 (A professional, effective and ready-to-use Multi-select ComboB

    there's a common issue for such COMBO control is the hook. I think you can fix.
    Try to use mouse fast scroll few times then the Listbox can't hide (EXE demo).
    On IDE, try to fast scroll by roller, there's a "guo guo" sound" but can hide sometime,sometime can't.
    Attached Images Attached Images  
    Last edited by Jonney; Jul 1st, 2018 at 09:46 PM.

  15. #15

    Thread Starter
    New Member
    Join Date
    Jun 2018
    Posts
    13

    Re: CheckBoxCombo 1.1 (A professional, effective and ready-to-use Multi-select ComboB

    Jonney,

    I suppose the root issue might be related to the input speed in foreground window, which leads hook procedure to time out and hook is silently removed. I will look into this. Thanks.
    Last edited by PGBSoft; Jul 2nd, 2018 at 03:34 AM.

  16. #16

    Thread Starter
    New Member
    Join Date
    Jun 2018
    Posts
    13

    Thumbs up Re: CheckBoxCombo 1.2 (A professional, effective and ready-to-use Multi-select ComboB

    CheckBoxCombo 1.2 Released (05-07-2018)

    • Included FillList method. Now the list can be filled by a String/Variant type array
    • Fixed the scrollbar issue
    • Enhanced the mouse-click support for selecting/unselecting items in the list. Now mouse-click supports anywhere on the list item for quick selections
    • Fixed several minor bugs and general optimizations were done
    • Updated User Documentation

    Note: A must to have stable update.
    Last edited by PGBSoft; Jul 15th, 2018 at 01:29 PM.

  17. #17
    Hyperactive Member
    Join Date
    Jul 2007
    Location
    Essex, UK.
    Posts
    402

    Re: CheckBoxCombo 1.2 (A professional, effective and ready-to-use Multi-select ComboB

    After quick testing, the control now appears to be stable and a little faster. Well done, a really nice control.

  18. #18

    Thread Starter
    New Member
    Join Date
    Jun 2018
    Posts
    13

    Thumbs up Re: CheckBoxCombo 1.3 (A professional, effective and ready-to-use Multi-select ComboB

    CheckBoxCombo 1.3 Released (15-07-2018)

    • Made changes to ActiveX version to be fully compatible with VBA. Now it’s possible to use CheckBoxCombo in UserForms, Spreadsheets, Documents, etc. in Microsoft Office 32-bit editions
    • Optimized hooking mechanism
    • Fixed issues with MDI
    • Fixed issues related to Display Monitor
    • Fixed issues with mouse-wheel and scrollbars
    • Made minor changes to documentation

    Note: A more stable update.
    Last edited by PGBSoft; Jul 15th, 2018 at 01:29 PM.

  19. #19
    Frenzied Member
    Join Date
    Jan 2010
    Posts
    1,102

    Re: CheckBoxCombo 1.3 (A professional, effective and ready-to-use Multi-select ComboB

    fast scrolling still got “guo guo” sound.

  20. #20

    Thread Starter
    New Member
    Join Date
    Jun 2018
    Posts
    13

    Thumbs up Re: CheckBoxCombo 1.3 (A professional, effective and ready-to-use Multi-select ComboB

    Revision update 1.3.2 Released (18-07-2018)

    • Made internal improvements in hooking mechanism
    • Bugfixes in ActiveX

  21. #21
    Frenzied Member
    Join Date
    Jan 2010
    Posts
    1,102

    Re: CheckBoxCombo 1.3 (A professional, effective and ready-to-use Multi-select ComboB

    Quote Originally Posted by PGBSoft View Post
    Revision update 1.3.2 Released (18-07-2018)

    • Made internal improvements in hooking mechanism
    • Bugfixes in ActiveX
    More stable now. Thanks.

  22. #22
    Frenzied Member gibra's Avatar
    Join Date
    Oct 2009
    Location
    ITALY
    Posts
    1,543

    Re: CheckBoxCombo 1.3 (A professional, effective and ready-to-use Multi-select ComboB

    Quote Originally Posted by PGBSoft View Post
    Revision update 1.3.2 Released (18-07-2018)

    • Made internal improvements in hooking mechanism
    • Bugfixes in ActiveX
    Great job.

  23. #23
    Hyperactive Member Dragokas's Avatar
    Join Date
    Aug 2015
    Location
    Ukraine
    Posts
    457

    Re: CheckBoxCombo 1.3 (A professional, effective and ready-to-use Multi-select ComboB

    Hi, PGBSoft !

    Thanks for the control.

    I found the bug (both IDE/compiled, win7): when there is no place to drop down the list it drow up, but under the control a translucent rectangle appears (see screenshot #1).
    Furthermore, in such case, if you don't close the list, that rectangle left on the form forever (see screenshot #2).

    https://prnt.sc/k9bn3q
    https://prnt.sc/k9bn8s

  24. #24
    Frenzied Member gibra's Avatar
    Join Date
    Oct 2009
    Location
    ITALY
    Posts
    1,543

    Re: CheckBoxCombo 1.3 (A professional, effective and ready-to-use Multi-select ComboB

    Quote Originally Posted by Dragokas View Post
    I found the bug (both IDE/compiled, win7):
    No problem for me (tested EXE, IDE on Windows 10 - 1803)
    No problem for me (tested EXE on Windows 7 SP1)

    On Windows 7 SP1 IDE, the translucent rectangle appears for a moment, but then disappears when the list is displayed.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width