I have an Excel 2007 spreadsheet with two columns of data. Column A has a letter type and Column B has a letter fragment.
What I would like to do is create a userform , in excel 2007, which has a combox box with various letter types in it and a listbox . If you select a particular type of letter e.g. DV1 from the combobox the listbox brings up the relevant letter fragment options which you can then tick. A letter is then produced, using vba, from the options which you have selected.
Attached is a sheet with an example of the data.
Any help appreciated