+ Reply to Thread
Results 1 to 4 of 4

code called from module check first data only not all of them

  1. #1
    Registered User
    Join Date
    05-13-2011
    Location
    Egypt
    MS-Off Ver
    Excel 2003
    Posts
    49

    code called from module check first data only not all of them

    attached is test workbook , i have 3 sheets :
    1- reservation
    2-Finished
    3- waste

    I want when i click on Check button on reservation sheet , check if the skill card no. is founded in the other 2 sheets.

    that all what i try to accomplish

    what's happening is that , it working well with finished "code in command button area", for code on module it check just the first data then stop not check all data in reservation
    Attached Files Attached Files
    Last edited by suny100; 05-22-2011 at 11:57 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    06-19-2010
    Location
    Holywell, N Wales, UK
    MS-Off Ver
    Excel 2013
    Posts
    470

    Re: code called from module check first data only not all of them

    Hi suny100
    This code snip should get you a bit further

    Please Login or Register  to view this content.
    Note your wbook is 2Mb in size otherwise I would have uplaoded it back for you?

  3. #3
    Registered User
    Join Date
    05-13-2011
    Location
    Egypt
    MS-Off Ver
    Excel 2003
    Posts
    49

    Re: code called from module check first data only not all of them

    Really thanks a lot for your great help

    really many many thanks
    Last edited by suny100; 05-21-2011 at 07:08 PM.

  4. #4
    Valued Forum Contributor
    Join Date
    06-19-2010
    Location
    Holywell, N Wales, UK
    MS-Off Ver
    Excel 2013
    Posts
    470

    Re: code called from module check first data only not all of them

    Glad to be of help
    Please mark this thread as SOLVED if it has met your requirement

+ Reply to 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