Worksheet_Change from a validated list

[Guest]

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

 

[Bob Phillips]

Excel 97?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Excel 2000, running on XPPro

JonR

Excel 97?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[excelexpert1973]

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

 

[excelexpert1973]

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

 

[NickHK]

Then validation triggers a WorkSheet_Change event.
Unless events have been disabled. Maybe due to a partial running of your
code ?
We are talking about Excel's Data Validation ?

NickHK

 

[Guest]

Thanks Nick,

I closed the file and re-opened it. That seemed to reset whatever was
hanging up. It works now.