PDA

View Full Version : Sleeper: Auto sorting validation list



smowen
10-31-2007, 03:37 PM
In Excel I have a validation list which is made up of formulas taking values from another worksheet.

I want to have a macro which automatically sorts the list if a value within the list changes.

I tried using a worksheet_change macro, but this only works if the content of a cell changes and doesn't work with formulas.

Is there any way to do this?

Cheers

Bob Phillips
10-31-2007, 03:52 PM
Use the worksheet calculate event.

smowen
11-01-2007, 03:16 AM
Could you explain how to do this using a worksheet calculate event please?

Thanks

Bob Phillips
11-01-2007, 03:55 AM
Actually, this won't work because if the list points at values elsewhere, sorting it will just sort the formulae, not the data.