Open validationlist when cell is active
 

Dear All,

The only input from the user is to set the values in column F all having a
validationlist ( about 250 rows ).
Soo I want to open the validationlist when the cel becomes active soo the
user shoeld not have to click the open button.
Or is there a keystroke to open a validationlist.

Thanks²

Filip

Open validationlist when cell is active
 

Possibly

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim v As Long
If Target.Count 1 Then Exit Sub
v = 0
On Error Resume Next
v = Target.Validation.Type
On Error GoTo 0
If v = xlValidateList Then
SendKeys "%{DOWN}"
End If
End Sub


this would be placed in the code module for the sheet (right click on the
sheet tab and select view code).

--
Regards,
Tom Ogilvy


"Filips Benoit" wrote in message
...
Dear All,

The only input from the user is to set the values in column F all having a
validationlist ( about 250 rows ).
Soo I want to open the validationlist when the cel becomes active soo the
user shoeld not have to click the open button.
Or is there a keystroke to open a validationlist.

Thanks²

Filip