I have a worksheet with two cells that should be edited together. One contains date and time information and the other contains hours of work remaining. Normally, if one is changed, the other should also be changed. If either cell is edited, I want to display a message suggesting that the other cell should be checked and edited.
Can anyone help me with that?
What are the cells?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
The cell addresses are:
C19 (This is formated as a number with one decimal.)
C20 (This is formated as Date & Time.)
Both these cells are manually updated.
Try placing this in your worksheet change event
Please Login or Register to view this content.
That worked great. Thanks!
Glad to help, thanks for the rep, and welcome to the forum.
If you don't mind please mark the thread as [SOLVED] using the thread tools at the top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks