Closed Thread
Results 1 to 3 of 3

retrive data from spreadsheet on PREVIOUS and NEXT commands in User Form

  1. #1
    Registered User
    Join Date
    05-02-2009
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question retrive data from spreadsheet on PREVIOUS and NEXT commands in User Form

    Can any one guide me with example?


    I have 250 rows of data and 35 columns of data.
    These are received through various text fields in the user form and stored in the spreadsheet.
    I want to get retrieve the data on selecting PREVIOUS and NEXT command button.
    On selecting the PREVIOUS command button I should get entire row (35 columns) details of the previous row to the active row in the respective fields of the user form. Similarly I need this for NEXT command button also.


    thanks and regards
    Krish

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: retrive data from spreadsheet on PREVIOUS and NEXT commands in User Form

    I spent time yesterday telling you to read the Forum Rules, this is basically the same as your previous question about userforms. Do not start a new question on the same subject, continue with the original. I ponted you to an example that contains code that you can use, in fact I answered two of your questions, neither of which you have responded to.

    Either read & follow the simple rules here or don't post!
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: retrive data from spreadsheet on PREVIOUS and NEXT commands in User Form

    You were on line when I posted the previous post, you haven't bothere to reply, thread closed

Closed Thread

Thread Information

Users Browsing this Thread

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

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