Why not use a ScrollBar.
As with the Spinner set LinkedCell to (say) E1, Min Value to 1, SmallChange
to (say) 8 but this time set the Max value to total number of records in
your list.

Private Sub ScrollBar1_Change()
Range("E4") = Range("myList")(ScrollBar1.Value, 1)
' or name the DV cell
' Range("myDVcell") = Range("myList")(ScrollBar1.Value, 1)
End Sub

Private Sub ScrollBar1_GotFocus()
' this just to ensure Max is always correct
ScrollBar1.Max = Range("myList").Rows.Count
End Sub

You can have your cake and eat it if you define the dynamic range, myList8
and use as in the previous example for your custom DV list.

You could use a Forms Scrollbar with similar properties but assign a macro
to make the change, and possibly update the Max value of the Scrollbar.

FWIW, though not useful for DV -
=INDEX(myList, theLinkedCell)

Regards,
Peter T

"RD Wirr" wrote in message
...
Hi Peter,

As you describe, I have set it up and it does indeed work as you intended.
Sorry I wasn't more clear at first. For my application I need to be able
to
manipulate the data in the DV cell with both the dropdown and the spinner,
calling up values from the same list. This is so that I can search through
the whole long column for a particular date value at anytime but also be
able
to increment the value in that same cell with the spinner. I need to have
coarse control with the dropdown and fine adjustments in the same cell
with
the spinner.

The problem is; the DV dropdown list supplies only the dates of which
there
are usually many of the same but which are unique with the included time
stamp. But this isn't enough information for the user to identify a
specific
record. So we still must scroll through these row entries, while reading
the
data (v)looked up from the associated row records. A drop down list is not
as
easy to use as a spinner for these smaller shifts and also, a DV dropdown
always opens with the first row in the list so scrolling through the whole
long list each time just to shift down a few rows is really cumbersome.

For sure this is an application better suited to Access or some proper DB
but as usual systems tend to be outgrown over time and we have to deal
with
them until we find or build a replacement. Anyway, I appreciate your help
on
this issue. If you know a way to load this DV cell from both the drop down
list and the spinner, I will be very grateful.
Thanks,
RDW

"RD Wirr" wrote:

I have an application that has a validation drop down list that
references a
long list of dates to lookup data associated with the dates. This works
fine
but since the list is long, it is cumbersome to advance incrementally
with
the dropdown list so I would like to have a spinner that can advance the
value in my validation cell incrementally. I still want to keep the drop
down
list for deep lookups but then be able to increment the value in that
same
cell with the spinner. Anyone have a solution for this?
Thanks,
RDW