Hi

DOnt know if this will solve your problrm but here goes.

If I understand you right, D5 gets updated on the basis of a dropdown
list. If you create this dropdown list using a "combobox" provided in
the forms toolbar and assign your macro to that, the sheet should
refresh.

Hope it helps.

Prasad

JonR wrote:
Hi

I'm trying to program a sheet to automatically refresh (run a refresh macro)
whenever the value of cell D5 is updated. D5 is set up as a validated list,
where the allowed values are a list of dates. A drop-down list enables the
desired date.

Here's what I have so far. For some reason, the code doesn't execute when a
new value is selected in the drop-down.

Private Sub Worksheet_Change(ByVal Target As Range)

Application.EnableEvents = False

Refresh 'macro that updates & sorts the information on the page

Application.EnableEvents = True

End Sub

Thanks in Advance

JonR