Running code from list

Hi
I want to put a validation on a cell which will contain a list of months.
When the user selects a month from the list I want to automaticallyl filter
the data on a worksheet and create a chart from the filtered data.

The code is written and the validation is in a list on the cell.

How do I get the information selected from the list into the function so I
can filter the worksheet??

Any ideas gratefully received.

The value is in the cell. Trigger the action using the Change event.

http://www.cpearson.com/excel/events.htm

Chip Pearson's page on events if you are not familiar with them.

--
Regards,
Tom Ogilvy

"Mick" <[email protected]> wrote in message
news:[email protected]...
> Hi
> I want to put a validation on a cell which will contain a list of months.
> When the user selects a month from the list I want to automaticallyl
filter
> the data on a worksheet and create a chart from the filtered data.
>
> The code is written and the validation is in a list on the cell.
>
> How do I get the information selected from the list into the function so I
> can filter the worksheet??
>
> Any ideas gratefully received.
>
>

Thanks for the info. i'll give it a go
"Tom Ogilvy" <[email protected]> wrote in message
news:[email protected]...
> The value is in the cell. Trigger the action using the Change event.
>
> http://www.cpearson.com/excel/events.htm
>
> Chip Pearson's page on events if you are not familiar with them.
>
> --
> Regards,
> Tom Ogilvy
>
> "Mick" <[email protected]> wrote in message
> news:[email protected]...
>> Hi
>> I want to put a validation on a cell which will contain a list of months.
>> When the user selects a month from the list I want to automaticallyl
> filter
>> the data on a worksheet and create a chart from the filtered data.
>>
>> The code is written and the validation is in a list on the cell.
>>
>> How do I get the information selected from the list into the function so
>> I
>> can filter the worksheet??
>>
>> Any ideas gratefully received.
>>
>>
>
>