I have a worksheet with a combo box on it. Each time I execute one of
my macros, I need all the values in the combobox to be cleared out,
then filled with all the dates between two ranges. In my sheet, I have
two cells with two dates. In P3 I have 1/1/1998. In P4 I have
2/1/2006. I need the combobox to list all the months in this range. I
would like to have the formatted as 1998 Jan, 1998 Feb, etc...

The entire combo box would have all the dates from Jan 1, 1998 to
(currently) Feb, 1, 2006.

1998 Jan
1998 Feb
...
...
...
2006 Jan
2006 Feb

Any ideas?? I don't have all my dates listed out, so I'm wondering if
that would be a problem?

TIA,
DejaVu


--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629
View this thread: http://www.excelforum.com/showthread...hreadid=528631