Updating the data for a ComboBox

slimpickens · Mar 20th, 2002, 04:29 AM

Hello,

I have the data which would populated my combobox in Sheet2 on my workbook. They are the months of the year formatted as January-02 thru to December-02.

Is there any way I can have these updated automatically on the first day of the proceeding years.

Thanks

Carol

Dave Hawley · Mar 20th, 2002, 05:02 AM

Hi Carol

Have a look at my examples od Dynamic ranges here: http://www.ozgrid.com/Excel/DynamicRanges.htm

They can be made to expand each day, week, month or Year.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 04:29 AM	#1
slimpickens New Member Join Date: Feb 2002 Posts: 35	Hello, I have the data which would populated my combobox in Sheet2 on my workbook. They are the months of the year formatted as January-02 thru to December-02. Is there any way I can have these updated automatically on the first day of the proceeding years. Thanks Carol

Mar 20th, 2002, 05:02 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi Carol Have a look at my examples od Dynamic ranges here: http://www.ozgrid.com/Excel/DynamicRanges.htm They can be made to expand each day, week, month or Year.