hey yers.

I have a picklist, which i am gathering from a named range, using the data validation -> list = named range ETC.

now, i am guessing it prolly wont b possible, but im still hoping to give it a shot:

can i assign a macro to run every time this list item changes?

when the list changes, i wish to fetch some data from another sheet, to re-populate my sheet (this i know how to do), but i dont know how to initiate the macro when it changes.

would i need to use the combobox of the forms? or is it possible from the normal drop down?.

if i need to use the combobox it isnt too much of a bother, EXCEPT: how do i refer to a combo box item that is selected via the VBA ide in the code?.... (so i can place the value in a cell, and not just the list index (which the LINK TO CELL option does) so i can easily use it in all the formulae in my workbook ETC...

it would be alot more helpful if i didnt have to use the combo box tho..... ne one wanna help me wid dis?

Tnx.