Data Validation Calender Dropdown

[andyp161]

Hi there,

Is it possible that, having created a dropdown menu listing dates fro
01/01/04 - 31/12/04, is it possible to programme excel so that th
dropdown menu will always open up on the current date?

Many thank

 

[Debra Dalgleish]

The data validation list will default to the item that matches the
cell's value. You could use event code to automatically enter the
current date when the cell is selected.

For example, the following code enter the current date in cell D4. The
code should be stored on the worksheet module (right-click the sheet
tab, choose View Code, and paste the code where the cursor is flashing)--

'================================
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = False
If Target.Address = "$D$4" _
And Target.Value = "" Then
Target.Value = Date
End If
Application.EnableEvents = True
End Sub
'============================