+ Reply to Thread
Results 1 to 6 of 6

I need to add a verify segment to this code

  1. #1
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    I need to add a verify segment to this code

    I have the following code which request the weight entered. I need to add a step where in which you re enter the weight to verify correct weight entered. and if the two weights don't match then msgbox "weights dont' match.

    HTML Code: 

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: I need to add a verify segment to this code

    Without seeing your workbook, I can only guess at what you're going for, but here's my effort:

    Please Login or Register  to view this content.
    If the cell is empty, it'll run your IF clause with the InputBox. If the cell isn't empty, it'll prompt the user to enter the supposed weight. If that weight matches the cell value, it will proceed. If it doesn't match, the user gets an angry message box and the sub ends. Let me know how it goes...

  3. #3
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: I need to add a verify segment to this code

    This is almost what I need. I need it to be kind of one motion. for instance I click the button and enter the weight. when I hit ok it ask me to re enter the weight

  4. #4
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: I need to add a verify segment to this code

    Your original procedure had an IF clause dealing with cases where the barrel weight might not have been entered in the appropriate cell. Do you want to get rid of that check, so that regardless of what's in the cell, the procedure asks the user what the weight is, then asks again as a double check?

  5. #5
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: I need to add a verify segment to this code

    if it works. I only put weights in one at aa time.

  6. #6
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: I need to add a verify segment to this code

    Okay, see if this one better captures what you're looking for:

    Please Login or Register  to view this content.

+ 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. Problem with code to verify cell
    By leleco in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-05-2015, 04:10 PM
  2. Code to verify password on login
    By Nitefox in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2014, 03:05 PM
  3. [SOLVED] Code to verify text box contains data.
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 12-26-2013, 11:19 PM
  4. [SOLVED] Returning Segment Description
    By PERE in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-30-2013, 12:17 AM
  5. need vba script to verify postal code format
    By gibsongk55 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-08-2011, 03:32 AM
  6. Verify A String Segment As Number using Reg Expression
    By bdb1974 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2011, 05:29 PM
  7. Autoshape for Pie Segment
    By Francouk in forum Excel General
    Replies: 8
    Last Post: 01-30-2009, 10:15 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