Feature: `SwiftSelectList` A Custom VBA UserForm Control

[vbamagician]

Feature Request: Custom VBA UserForm Control

Description

As a VBA developer, I would like to have a custom UserForm control that provides the following features:

1. SourceList and SelectedList: The control should consist of two ListBox controls, lstSourceand lstSelected, to display the list of data. The lstSourcewill contain the source data, and the lstSelectedwill display the data selected from the lstSource.
2. TextBox: The control should have a TextBox named txtSearchBox, which allows users to search for items in the lstSource. When the search box is empty, the lstSourceshould display only those items that are not present in the lstSelected.
3. Double-Click Event: When a user double-clicks an item in the lstSource, it should be removed from the lstSourceand appended to the lstSelected. Similarly, double-clicking an item in the lstSelectedshould remove it from the lstSelectedand append it back to the lstSource.

Example

Here's an example of how the control should behave:

1. Initial data in the lstSource:
   • Item 1
   • Item 2
   • Item 3
2. Initial data in the lstSelected: (empty)
3. User Action:
   • Double-click on "Item 2" in lstSource.
4. Expected Result:
   • lstSource: Item 1, Item 3
   • lstSelected: Item 2

Expected Look

Additional Information

• Please ensure that the control is implemented in a way that is compatible with VBA UserForms in Microsoft Excel and other Office applications.
• The control should handle edge cases, such as handling the situation when no item is selected or when the search box is empty.
• Consider providing an initialization subroutine (UserForm_Initialize) to set up the initial data in the lstSource for demonstration purposes.

Acceptance Criteria

• The control should be implemented using VBA code within a UserForm.
• The control should have a TextBox (txtSearchBox) to search for items in the lstSource.
• Double-clicking an item in the lstSourceshould move it to the lstSelected.
• Double-clicking an item in the lstSelectedshould move it back to the lstSource.
• When the search box is empty, the lstSourceshould only display items not present in the lstSelected.

Priority

This feature is of High priority as it would significantly enhance the usability of VBA UserForms in our projects.

Environment

Microsoft Excel 20XX or other Office application with VBA UserForm support.

References

If applicable, provide any references or examples that might help with the implementation.

Feel free to copy and paste this template into a new GitHub issue. Modify it as needed to add any specific details or context related to your project. Good luck with your development!