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:
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:
Without seeing your workbook, I can only guess at what you're going for, but here's my effort:
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...Please Login or Register to view this content.
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
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?
if it works. I only put weights in one at aa time.
Okay, see if this one better captures what you're looking for:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks