If you have a ComboBox in a User Form you can go to the properties of the ComboBox and enter 2 in the ColumnCount property
When you attach data to the combobox e.g. ComboBox1.List=strMyData()
Use an array with two dimensions, e.g. strMyData(9, 1)
The value 9 will be one less than the number of items in your drop-down list (remember that there is a zero element to the array) and 1 is for the two dimensions
In each of the two elements 0 and 1 enter your data and your subtitle.
Repeat for as many items in the list
Fill and Link the array to ComboBox1.List when the User Form's Initialize code is run.
The Combo box will now show your information with the 'subtitle' next to it.
The ComboBox BoundColumn property will determine if the value returned from the ComboBox is the first or second element, ie your data or your subtitle. Setting BoundColumn to 1 will ensure that it is the data that is returned not the subtitle.
The list will look like this:
Data A Subtitle a
Data B Subtitle b
Data C Subtitle c
Data D Subtitle d
Data E Subtitle e
Data F Subtitle f
Data G Subtitle g