+ Reply to Thread
Results 1 to 3 of 3

message box will pop-out, when number is used already.

  1. #1
    Registered User
    Join Date
    10-08-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2010
    Posts
    2

    message box will pop-out, when number is used already.

    hi,

    i have a system, that has a voucher number, payee, date, check number and amount. my system is i'll run the form then i'll input it to the textbox (voucher number, etc) after that i'll click cmd btton then the values will be entered to the sheet1, like this:

    vouchernumber 111111 payee 111111 date 111111 checknumber 11111 amount
    2012-0001 1111111111 paulo 1111111 12-4-90 111 123 111111111111 10.00
    2012-0002 1111111111 pau 11111111 12-4-91 111 1234 111111111111 5.00


    While in the form, i want to check the number in (vouchernumber and checknumber) if its used already, and when its used already the msgbox will pop-out. Number already in used.

    Thank you!

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: message box will pop-out, when number is used already.

    Somethig like this:

    Please Login or Register  to view this content.
    Of course, need to define Start at the beggining of the code to run it again.

  3. #3
    Registered User
    Join Date
    10-08-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: message box will pop-out, when number is used already.

    thank you for replying, unfortunately not working.

    for example, i have a tbCheckVoucher and cmdInput when i put a value on tbCheckVoucher the value of it, will be inserted on sheet1.
    like this:

    1111 Column11111111111A1111111111111111111111B
    111111111111111111111Check Voucher No.1111Payee
    1111111111111111111112012-000111111111111Paulo
    111111111111111111112012-0002111111111111Jonh
    after that i will input again a value on the tbCheckVoucher same as 2012-0001. and when i click the cmdInput. the system should check if the number is already in used, and if its used already msgbox will appear telling, "Number already exist"

    Thank you sir..
    Last edited by Oluap; 10-08-2012 at 02:54 AM.

+ 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