Choose next record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select drop down menu option using libre-calc macro 0
Excel Pivot table - getting back to the skeleton template 3
Pasting cell contents into a macro 1
Access Automatically Send a notification email once a record is added 0
Copying data to the next blank row 0
Recording new Macro won't reset drop downs 3
Inserting data to next available empty cells 2
Drop down list and macros? 1

Back
Top