A
Aussie
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
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