+ Reply to Thread
Results 1 to 6 of 6

retrieve the data stored in the worksheet for FIRST/LAST/PREVIOUS/NEXT command option

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

    Question retrieve the data stored in the worksheet for FIRST/LAST/PREVIOUS/NEXT command option

    Dear all

    Thank you for your help.

    Here I have attached the Excel Workbook which I have prepared. Please find the user form. I have created user form namely “frmDespatchAdviceEntry”. I wrote macro such that all inputs keyed in user form will be saved in cells from cell”A” to cell”AK”.

    Please help for the followings:
    1) I could not call the user form through the button click event from Work sheet.

    2) I have set (through initialize subroutine) default values for all the fields in the user form but it works only I click the command button “CLEAR” .I want this to be done whenever the user program called i.e. without selecting the CLEAR command button how to call initialize subroutine during opening the user form.

    3) I have four command buttons FIRST/LAST/PREVIOUS/NEXT
    How to retrieve the data stored in the worksheets for FIRST/LAST/PREVIOUS/NEXT

    On selecting FIRST “ I want to get the data stored in FIRST row in the respective fields of User form”

    On selecting LAST “ I want to get the data stored in LAST row in the respective fields of User form”
    Similary “Previous” and “Next “.

    PLEASE HELP.

    Best regards
    Krish
    Attached Files Attached Files
    Last edited by krish_kg; 05-09-2009 at 05:50 AM.

  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: Please help for this VBA Programming

    Welcome to the Forum. If you want free help we expect you to read & follow our Rules.

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    Hope that helps.

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

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    05-08-2009
    Location
    Beijing
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Please help for this VBA Programming

    I've made some changes about your problem 1 and 2.

    the 3rd one is much more complicated, and you need a pointer to identify which row is currently under your operation, so that you can use the offset, and make it available for your 'PREVIOUS' and 'NEXT' button.
    Attached Files Attached Files

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

    Re: Please help for this VBA Programming

    Dear friend,

    Thanks for incorporating the changes. I appriciate your timely help.

    I am really worried on Sl No 3. can you guide me step by step procedure?



    best regards
    Krish

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

    Re: Please help for this VBA Programming

    You all need to read the Forum Rules - you are asked not to answer any questions until a moderators requests have been met!

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

    Re: retrieve the data stored in the worksheet for FIRST/LAST/PREVIOUS/NEXT command op

    Thanks for taking the time to read and comply with the rule .

    The DataBaseForm contains all the code for this. See

    http://www.excel-it.com/vba_examples.htm

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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