Thank you Graham, the link was very useful and I managed to follow everything but I am now thinking that maybe this isn't what I need for example I have a report that is issued in paragraphs and throughout the paragraph at present I have drop boxes with various options to select e.g. Satisfactory/Unsatisfactory/Upon completion/Not suitable/After remedial work. Only one of these can be selected and inserted into the paragraph but I would like to be able to select more than one.

Do you think that userform and listbox are the best way to go about this?