You can set the Font Size of your Combobox (activeX control) object For example: ComboBox1.Font.Size = 12
On Tue, Aug 31, 2010 at 8:27 AM, Meimei <xxu8810...@gmail.com> wrote: > I am writing a simple vba program. I used a few comboboxes in the > program. But I found that as I click on the combobox, the font size in > the drop-down list gets smaller each time, and after a few clicks, the > font is too small to even see. Does anyone know why it happens? > Thank you! -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe