View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eclypse Eclypse is offline
external usenet poster
 
Posts: 4
Default Loading a Combo Box with the months of the year

Hi,

I'm trying to make a form (using Excel VBA) that will offer a drop-
down combo box to choose a month.

The only way I've been able to do this is to have a sheet containing
all the months, and load the list from there. If possible though, I'd
like to avoid having nearly-empty sheets hanging around.

Is there any way to load the months directly into the combo box list
through VBA?

Thanks!
- Eric