+ Reply to Thread
Results 1 to 7 of 7

Next and previous buttons not working

  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    61

    Next and previous buttons not working

    Please help

    i created thread 2 days ago but havnt got any reply

    please help me to code next and previous button
    Attached Files Attached Files

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Next and previous buttons not working

    Hello vijaynadiad,

    It is because you do not have any Code for those two respective Buttons. I have made the "Next" Button to work, assuming it is supposed to do the same thing as the "Add" Button.

    As for the "Previous" Button, I do not know how you define "Previous". Would it be the first, second or last entry, or would you want the user to select a "Previous" from the already entered Data?

    Having given you this, you would presumably be able to take it from here and sort it out the way you want it.

    Also see the "Please consider" note at the bottom of this post.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  3. #3
    Registered User
    Join Date
    05-13-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    61

    Re: Next and previous buttons not working

    Winonbro...

    first i will click first record record button

    then i will click next to go on 2nd row , then 3 row, 4th ...

    then if i am on 5th row previous button will take me to the 4th row, 3rd row, 2nd row , 1st row

  4. #4
    Registered User
    Join Date
    05-13-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    61

    Re: Next and previous buttons not working

    today also no reply

  5. #5
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Next and previous buttons not working

    Hello vijaynadiad,

    The best way I could solve your issue, was to add a second ListBox to the UserForm in which you can scroll up and down and select any entry you are looking for. With any such selection the TextBoxes on the Form will be populated with all relevant details.

    Sample WorkBook attached.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    05-13-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    61

    Re: Next and previous buttons not working

    thanks winon working very well you designed so nice i appreciate your work .. thanx man............. god bless you

  7. #7
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Next and previous buttons not working

    Hello vijaynadiad,

    You are welcome.

    It took me some time to come up with a workable solution, and I am glad that it works for you as well.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel 2010 VBA - Next and Previous Buttons
    By eemiller1997 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 11-28-2012, 11:01 AM
  2. Previous Task and Next Task buttons aren't working
    By top.C.Crets in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-07-2012, 08:27 AM
  3. Previous working days date (Mon-Fri working week).
    By intothewild in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-22-2011, 01:00 PM
  4. Next & Previous Buttons
    By Taylor86 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-23-2010, 09:11 AM
  5. Replies: 1
    Last Post: 01-26-2005, 04:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1