troubleshooting Question

MsgBox to populate a cell once another cell is populated

Avatar of GrahamSA
GrahamSAFlag for South Africa asked on
Microsoft Excel
5 Comments2 Solutions536 ViewsLast Modified:
Hi

Just want to say thank you for all the help, this project is starting to look great!!

OK.

This spreadsheet has a "Date" column and on the other end there is a column called "Standing Time"

Here is what needs to happen, once I add the date and try move from that cell a MsgBox needs to come up. ("Please add your Standing Time Hours __________") then once added the number populates the relevant cell then the MsgBox asks ("Did you fill in a Standing time Note") Yes/no

The Yes/no does not have to do anything but be a confirmation that the note is filled in.

Hope that this is a fun one :)
I think i would have fun with it if i new how.


Spreadsheet layout attached
 Standingtime.xlsx
ASKER CERTIFIED SOLUTION
Steve
Cost Accountant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Top Expert 2012

The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.

Join our community to see this answer!
Unlock 2 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros