View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aussie Aussie is offline
external usenet poster
 
Posts: 2
Default Choose next record

Hi,

I have a data set that is updated via a data form. I can enter the data on
the form, and a macro updates the data set (on another sheet). I can then
select the next record via a drop down box, and a macro button retreives the
data when pressed.

My Problem: I want to add a button that allows me to move to the next row
(either up or down) without going through the drop down box. I envisage
having it attached to a 'spin button' if possible.

Can you advise how this can be done to first get a macro (?) to select the
next row, and secondly how to attach it to a button.

Cheers