An easy to use properties control, a bit like the one in the VBA IDE - see here for a screenshot
It allows for Key (property names) / value pairs where the values can either be text boxes or comboboxes. The size of the control is set by the size of the label that is placed on the form at design time.
The code to make it all work is a bit in-depth, but actually using the control is pretty straightforward, just copy all the classes in the workbook into your project and use the code from the userform as a guide as to how to set things up.
It includes:
- The ability to add new properties at any time (though you can't remove them)
- Easy error adding for validation - see here for a screenshot
- Easy to use key/value pairs in the form of a dictionary
- Cancellable events for changing values and adding new properties
- Choice of textbox or combobox for entering values
- Nifty interfaces to keep things as simple to use as possible
- All VBA (with a reference to the scripting runtime) so it's easy to tinker with if you want to improve / adapt and has no other external references
Hope its useful for someone else
Bookmarks