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

Maybe you could drop your userform and use Data|Form. It might be sufficient.

Or if you want sample code, take a look at John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC).

Aussie wrote:

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

--

Dave Peterson