Creating a Macro for Cell Validation

[alfavest]

I wonder if anyone can help out a newbie with "Macros" and the "Validation" feature on Excel.

I am using the "List" function within "Validation" usng a drop down window to view from a cell (i.e., A1) data from several other cells (i.e., A2, A3, A4). The problem is that if I leave the A1 cell on the A2 cell info, when the data changes in the A2 cell, the A1 cell does not automatically update the info. I need to manually click on the drop down window to get the updated info.

Can anyone suggest a Macro that will automatically update the info in the A1 cell? Thank you.

[MSP77079]

Put this code on the worksheet containing the drop-down. I named the Range containing the list "listFill".

It would be better if the Public declaration was in a Module. But, it seems to work here.

Please Login or Register  to view this content.