Fill a combobox

[Defré]

Hi all,

I wanna fill a combobox with a range of cells that contain some characters.
Some of them are subscript or superscript.
That I want to do, is to fill the combobox preserving the format of the characters in the original cells.
Now I am using the following code to fill my combobox named ZoneList but I am sure it misses something for that I want.

For i = 1 To 10 Step 1
ZoneList.AddItem Sheets("Feuil1").Cells(i, 1).Format
Next i

Thank for your help
Defré.

[Hassan Basri]

Here is a list of combo boxes, pick the style that you want, there are demos as well as full source-code:

http://www.vbaccelerator.com/home/Vb...oxes/index.asp

[AIS4U]

You asked this same question in the VB.Net Forum section.
So, which language do you want to do this in.

Making duplicate postings is frowned upon as well as being very confusing to the member who are trying to help you.

Thank You