Hi
I have created Time tracker. in that associates are updating there time tracker for each transaction..but i want them not to end the transaction (End time) without updting column D,E,I and without updating these column that particular transaction should not be end..
Please suggest..
Attached the sheet for your reference
Last edited by anwitha; 12-09-2010 at 04:31 AM.
Use Data Validation for this.
1) Highlight G5:G124
2) Select Data > Data Validation (you may have to hunt for this in xl07)
3) Use the following settings:
Validation Criteria:
Allow: Custom
Formula: =COUNTA($D5,$E5,$I5)=3
You can use the Error Alert tab to create a more informative error message, if you want.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I have tried it in Data Validation as u have suggested above..but still its not working...Could u check this in my sample attached sheet and reply me?
I followed steps 1-3 as given exactly and it works. You not being able to follow 3 short steps is a very big concern.
Sir I have done the same thing as u suggegsted but it wasn't working..and again i have opened the sheet which you have attached but as soon as i opened this sheet i am getting the error dialogue box "Run Time Error - 438"
The error you are getting is coming the VBA in your workbook, not from the formula and the data validation I gave you. The VBA installed in your workbook is faulty in some way. Unfortunately the code is password protected so I can't suggest what the problem might be. Most likely some macro designed to run when the workbook is first opened is written incorrectly.
I have applied the formula and start working but even if D,E,I column is blank i am able to end the transaction buy clicking the stop button my query is it should not allow the user to stop until and unless they update these three column and also when the user completed the partulcar transaction and going fo next one by clicking start then the previous transaction colulmn should not be edited..here i have attached the sample sheet and also VBA code has been unprotected..Please check..
I'm having significant problems reading/using your sheet, something I don't usually have a problem with.
1) Delete the two buttons and the code you have already created.
2) Insert a single commandbutton
3) Double-click the commandbutton to open the Sheet module for that button and paste in this code:
4) Edit the underlined part if needed to match the actual name of the commandbutton
Please Login or Register to view this content.
5) Close and save
6) Try it
Last edited by JBeaucaire; 12-09-2010 at 03:39 AM. Reason: code edited to add TIME TAKEN value in column H.
Here is the code in a new sheet, working fine for me...
Dear Jerry
Its working fine.now...thanks a lot..
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks