Userform Listbox problem

[redstang423]

Hey guys,

I am looking for suggestions on how to approach this problem I'm having. I have data that I need to allow people to edit using a user form. I don't want them editing the data directly since there is a good chance they would screw it up. The specific data is categories and category weight. Here is an example of what the data might look like and how it would ideally be displayed:

Category A | 25 %
Category B | 25 %
Category C | 30 %
Category D | 20 %

I need to be able to display both sets of information on the form, and it needs to be obvious how they relate. My first inclination was to create two listboxes and link them so that when you clicked a line on one, it would also highlight the same line in the other listbox. The category weight, however, may not be unique, so I can't just go to the value and I'm not aware of a property that relates to the position within the list box (i.e. 4th one down).

My next idea was to simply not worry about highlighting the appropriate weighting value in the second list box when the user clicks the category name (in the first list box) to edit. The issue with this method is that the list of categories could exceed the single screen (I'm constrained on the listbox size) and require scrolling vertically within the listbox for categories. The weighting would not scroll with it and it could easily confuse.

If I need to, I can go to one listbox and have a text box that populates the weighting when a category is clicked. I would highly prefer to have all the information visible at once though.

Does anyone have any suggestions on how I might do this?