Drop down list Font size

[Student1000]

How do you increase the font size of a drop down list in excel apart from zooming in. I have 10 dropdwnbxs each with about 16 items.
Everything works fine but users can not see the contents of each drop down box(fonts are too small). Is there a solution to this? (or just keep zooming in/out). Example i have a drop down box in A2 with source from F2:F17.....etc

How can i increse the font size?

 

[Student1000]

ComboBox Properties, excel

I have combo boxes in excel to allow bigger fonts. I want make the arrow beside the combobx(dropdown) to disappear when a cell loses focus. It seems that everytime i change a value in cell A2 and move down to A3, the arrow in A2 will be blocking some of the text in B2...
I want know what property or code i need to include to make the arrows disapper(after focus lost) without going back to each cell and double click it (sometimes doesnt work very well). I tried to take a picture of it but couldnt paste it here

Please, let me know if you know the solution to this. By the way i downloaded the example at http://www.contextures.com/xlDataVal10.html
and this example doesnt have this problem.


Thanks.

 

[royUK]

I would think that you haven't followed the instructions correctly. You should only have one combobox in the sheet.

 

[Student1000]

Thanks

Thanks, i got it to work, i was just makin it complicated than it really was...

 

[Student1000]

ListBox with Multiple Selection

How do i create a listbox that will allow me to make multiple selections(example Cities) and once selected, those selections are listed in a certain column(D1:D25). That is, if i select Chicago, New York, London in the listbox, these values should be populated in cell D1:D3, accordingly. Please let me know how to do this and if its imposible am open for suggestions.
Thanks

 

[royUK]

A MultiSelect listBox