Currently I display the selected comments in the list box by writing to
a report comment field on a spreadsheet. If the user has a custom
comment there is another area set up to record his custom comment by
using a text box on the user form. I would like to move to an
enviroment where the user can record a custom comment and then be able
to access it on later reports if needed. I am aware of the combo box
which I can set up a rowsource in the spreadsheet and add an item to
this range, but I was hoping to be able to build it into code so that
the VBA code automatically copies a new comment to the list box in the
initialize procedure. The list box has the capability of multiple
selections but the combo box does not. In this way I do not have to be
concerned about a user messing up an excel range and causing the
userform to bomb.