$$Excel-Macros$$ Excel VBA dynamically fill ComboBox?

Hello, I have a question on using VBA to programme several ComboBoxes whose items are dynamically filled? I have a worksheet containing country names, states, and product, such as CountryState Product 1 US MA Banana 2 US MA Orang

$$Excel-Macros$$ fonts in combobox keeps becoming smaller as it is clicked

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! -- --

$$Excel-Macros$$ How to copy the list of autofilter selection?

Hi all, I have a question about copy the list of unique values generated by autofiltering in VBA. For example, if in column A I have cells listing some animal names, dog, cat, dog, sheep, cat, dog, cat, cat, dog, sheep. If I do an autofiltering on column A, the autofilter will have the selection o

Re: Fwd: $$Excel-Macros$$ How to copy the list of autofilter selection?

nique list. Thank you so much!!! On Sep 10, 2:20 am, neil johnson wrote: > -- Forwarded message -- > From: Meimei > Date: Fri, Sep 10, 2010 at 6:55 AM > Subject: $$Excel-Macros$$ How to copy the list of autofilter selection? > To: MS EXCEL AND VBA MACROS > > Hi a